Please help,
I need to copy some rows from one worksheet to another, within
workbook, and paste them as text including some numbers (currencies)
as a string of characters "$13.00".
The destination worksheet cells are formatted as Text before the paste
operation.
In original worksheet cells are formated as text but after the "paste
as values" operation, cells are getting converted to "Currency"
formatting that strips "$" sign and zeros from two decimal places of
the record (in a destination cell I get just number 13). Is there a
way to force Excel to treat these entries as a text?
By the way, if I include an external workbook in a two step copy-paste
process, excel gives an option save as "Text",
within workbook I do not get that option.

How to work around that?

Georgee