Thread: date entry
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Aditya Aditya is offline
external usenet poster
  
Posts: 54
Default date entry
In cell A1, data is of 10 digit whose last 6 digit is in form of ddmmyy.
how can i get date, month and year in cell A2 from this.

e.g. A1 A2
UPR/010209 01 FEB 09
Reply With QuoteReply With Quote