Thread: Convert number to date
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Teri Teri is offline
external usenet poster
  
Posts: 77
Default Convert number to date
I am importing data from an AS400 program and my dates are formated as 10107
for January 1, and would be 110107 for November 1. Can anyone help me figure
out out to convert to 1/01/07 and 11/01/07?
Reply With QuoteReply With Quote