Thread: Keeping leading zeros in imported data (one digit month as 05)
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
exito816 exito816 is offline
external usenet poster
  
Posts: 1
Default Keeping leading zeros in imported data (one digit month as 05)
I am importing a csv into Excel. I need to retain leading zeros that occur
in a MMDD format. So that May 5th appears 0505 on csv but when imported it
appears 505. How can I do that easily?
Reply With QuoteReply With Quote