Thread: Excel Help
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Keith X. Terrell Keith X. Terrell is offline
external usenet poster
 
Posts: 1
Default Excel Help

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.