View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Jacq Jacq is offline
external usenet poster
 
Posts: 8
Default Converting Dates

I have a bunch of numbers on an excel file that are this format: 70220. I
would like to convert them to a regular date. I tried just formatting the
cells to dates, but it does not work. It should be 2/20/07. Can anyone help?

Thanks.