Excel 2000 - copying/pasting formula for validation purposes
Hi Roger
It worked if I placed the single quote ' at the beginning of the formula
after I had pasted it into another cell but not before.
Do you know if I can add the single quote ' automatically - some type of
add/replace function(??) at the beginning of the formula?
Regards, Silena
"Roger Govier" wrote:
Hi
Place a single quote ' in the cells, before you paste.
That will force the entry to be text.
--
Regards
Roger Govier
"Silena K-K" wrote in message
...
Is it possible to copy a formula from a cell and paste it as text?
I am writing spreadsheet validation documents which must show the formula
used in each calculated cell eg: =SUM(B8:B15) is written as SUM(B8:B15).
Thanks
|