Thread: Convert date (m/dd/yyyy) in text format into an excel recognised date
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Bob Phillips[_4_] Bob Phillips[_4_] is offline
external usenet poster
  
Posts: 834
Default Convert date (m/dd/yyyy) in text format into an excel recognised date
Try TextData To Columns, third page in the wizard.

--

HTH

Bob

"Rob P" wrote in message
...
is there anyway to convert a TEXT field with a date into an excel
recognised date?

or the other way around - convert a date in excel into text output?


Reply With QuoteReply With Quote