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.