Software

I haven't found a way, but here's teh workaround I use. You could make it into a macro, if you find it too annoying to do the steps manually. Hope it helps.
- copy column A to Column B
- highlight column B
- use EDIT:REPLACE to change all the equal signs to single quotes.
Column B now has the character representation of the exact contents of Column A

Here's a simple Function posted by John Walkenbach:

You need to create a very simple custom worksheet function using VBA. The steps below assume Excel 97 or later.

1. Press Alt+F11 to activate the VB Editor
2. Select your project in the Project window
3. Choose Insert Module to insert a new VBA module
4. Enter this function into the VBA module:

Function CellFormula(c) as String
CellFormula = c.Formula
End Function

Re-activate Excel by pressing Alt+F11 again. You can then use this new
function in a formula. Here's an example that displays the formula in cell
A1:

=CellFormula(A1)

If A1 does not have a formula, the function returns the cell's value. If
you'd like the function to display an empty string if the cell does not have
a formula, use this code:

Function CellFormula(c) As String
If c.HasFormula Then
CellFormula = c.Formula
Else
CellFormula = ""
End If
End Function

Posted by John Walkenbach of JWalk & Associates
Visit "The Spreadsheet Page"
http://www.j-walk.com/ss -----

This question was closed by the author