"Stephanie" wrote
Pre-formatting the cells did not work. I had tried that.
I guess the "pasting" overrides the cell format.

How about paste special text ?
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---