Hi Roger

One way.
Select your column of formulae
Ctrl+H to invoke Find and Replace
Find =
Replace #
Replace All
Copy your formulae and paste to new sheet.
Do a Find and Replace of # with = on both sheets.
--
Regards
Roger Govier

"roger finch" wrote in message
...
How do I copy a column of formulae as text to a new worksheet?
--
roger finch