Thread: How to convert data in General Format cells to dates
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
PE PE is offline
external usenet poster
  
Posts: 14
Default How to convert data in General Format cells to dates
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