Showing formulas and values in the same worksheet

C

christopher_platt

First of all, thank you in advance to anyone who can help. I'm looking
to create a worksheet in which I can have the formulas showing in one
column and the values calculated by the formulas in the next. I've
tried switching to formula view and copying the formulas, pasting them
into the next column, formatting them as text, and then switching out
of formula view but the pasted column switches back. Any ideas?
Thanks again,
Chip
 
H

Harvey Waxman

First of all, thank you in advance to anyone who can help. I'm looking
to create a worksheet in which I can have the formulas showing in one
column and the values calculated by the formulas in the next. I've
tried switching to formula view and copying the formulas, pasting them
into the next column, formatting them as text, and then switching out
of formula view but the pasted column switches back. Any ideas?
Thanks again,
Chip
Click to expand...

How about replacing all the '='s with nothing, using find / replace. Will that
work for you?
 
P

phildeaves

Harvey said:
How about replacing all the '='s with nothing, using find / replace. Will that
work for you?
Click to expand...


Or replace all the '='s with ''=' (in other words, add a quote mark to
make it appear as text)?

Hope this helps.

PhilD
 
Top