Thread: convert general to date
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Odd sent date when open attachment OWA Odd sent date when open attachment OWA is offline
external usenet poster
  
Posts: 2
Default convert general to date
I have imported a text file where all fields were character and came in as
general. They look like:
Nov 17 2009 9:39AM
I want to compute time differences between columns, but I can't get them
converted to Date/Time format.
Thanks very much for any ideas.
Reply With QuoteReply With Quote