Thread: DATE IN TEXT FORM - NEED TO CHANGE IT DATE FORM
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers,microsoft.public.excel
SSJ SSJ is offline
external usenet poster
  
Posts: 58
Default DATE IN TEXT FORM - NEED TO CHANGE IT DATE FORM
Hello!

When I download data into excel some of the dates in the data comes as:

2Sep'06


I edit the cell by taking out the apostrophe and the value becomes a date. What formula / function can I use to take out or clean this apostrophe and make it a date?

Thanks
SJ
Reply With QuoteReply With Quote