PasteSpecial, Formulas is intended to paste ONLY the formulas; that is, it
excludes formatting, comments, validation, etc. If you want to see the
formula in another cell, you can paste and then add the ' in front as you
described. OR, to see all the formulas, go to the menu bar and select Tools
Options, click on the View tab and select Formulas (a shortcut to toggle
this option is ctrl+~).

"BrianW" wrote:

I want to paste the formul's from a cell into another cell. Other
spreadsheet programs allow this for a single cell. I'm aware of paste
special , select formula button but the value is displayed. I can make this
work by copying the text in a fourmul and preceeding the past in another cell
with a ', but this is very cumbersom when I have to do it hundreds of times
in a column, and the result is not associative with the source.