Showing formulas and values in the same worksheet

[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

 

[christopher_platt]

Oh, and BTW, I'm using Excel v.X. . .

 

[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

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

 

[phildeaves]

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

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

Hope this helps.

PhilD