View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
DJ
 
Posts: n/a
Default converting 8-digit number to date

I have been given an Excel spreadsheet with numbers in 8-digit text format.
For example, 20020812 would be August 12, 2002. How do I convert these to
some sort of date field that will allow me to perform calculations (count
days from one date to the next)?