Thread: Change to day format
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Blue Fish Blue Fish is offline
external usenet poster
  
Posts: 3
Default Change to day format
Hello:

I have import a text file that the Raw Data is "20070722130054". How
can I make the excel to recognize as "2007-07-22 13:00:54"?

Thanks!
Reply With QuoteReply With Quote