When you import the data, specify that column (in the import wizard) as
being Text, not General.
--
David Biddulph

"Keith X. Terrell" <Keith X. wrote in
message ...
I imported data that came back erroneously in a date format (ex. 01-01-01).
I
actually need the data as it appears with the dashes inserted. When I copy
and paste special as a value, it gives me the whole number that is
equivalent
to the date (ex. 36892). How can I convert the cell to a text as it
appears?
I need to concatenate it with another cell.