View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Brandy Brandy is offline
external usenet poster
 
Posts: 52
Default Converting number into proper date format

Hello,

I export data dumps from a file and the date always shows as 20090707 rather
than a proper date. Is there a formula that will help me convert this into a
proper date file?

I will then want to change that date into just a day of the week. Is that
possible?

Any help would be greatly appreciated.

Warm regards,

Brandy