Thread: How to convert data in General Format cells to dates
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Roger Govier Roger Govier is offline
external usenet poster
  
Posts: 2,886
Default How to convert data in General Format cells to dates
Hi

Mark the column.
DataText to columnsNextNextDate use dropdown to select MDYFinish

--
Regards

Roger Govier


"PE" wrote in message
...
I have a sheet with many cells set to General Format containing "dates"
in
the form "20060913". Is it possible to select all these cells and
convert
the data to show the date in the form mm/dd/yyyy?

Would appreciate your help.




Reply With QuoteReply With Quote