Try the Trim and Clean functions on them and then copy
and paste values again.
However, you said you wanted Excel to treat all data as text.
A leading apostrophe causes Excel to treat the data as text.
Excel also ignores that character when processing the data.
You may not have a problem?
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware


"joeycalisay"
wrote in message
any other ideas?