problem

[Carol Gray]

I need to know how to change formulas eg: vlookup formulas to text.

CEGE.....

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

 

[Otto Moehrbach]

Carol
If I read your question correctly, you want to go to a cell that has a
formula, and change that formula from a formula to merely a text of the
formula. Is that right?
If that's what you want to do, then select that cell, go into Edit mode
(press F2) and put an apostrophe ( ' ) as the first character in the cell.
Press Enter. There is the formula as text. Note that this "text formula"
will not function as a formula anymore. HTH Otto