how do you convert formulas to just plain test?

F

Frank Kabel

Hi
you may format the cell as 'TEXT' (goto 'Format - Cells') and re-enter
your formula
 
N

Norman Harker

Hi Craig!

You can use
Select formula cell
F2
Home
Type a '

You can temporarily view formulas using Ctrl + ` [That's usual to the
left of the 1 key]

Also, I find the following UDF useful:

Function GETFORMULA(cell As Range) As String
GETFORMULA = cell.Formula
End Function

Once you have used that UDF you can Copy > Edit > Paste Special >
Values > OK

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
[email protected]
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
Top