EXCEL QUERY ON REFORMATTING DATE

[owendodd]

030109/01/M
HELLO I WAS JUS WONDERIN IF ANY BODY COULD HELP ME WITH THIS QUERY. ON THE ABOVE MESSAGE I HAVE A DATE AND A DOCUMENT NUMBER WHICH READS THE 9TH OF JANUARY 03 ALONG WITH A DOCUMENT NUMBER OF 01/M. IS THERE ANY WAY THAT A DATE CAN BE INTERPRETED FROM THE FORMAT OF 030109/01/M?

 

[fairwinds]

Welcome!

Try:

=DATE(20&LEFT(A1,2),MID(A1,3,2),MID(A1,5,2))

(and please do not write in caps)

 

[TheToeOfPooh]

Try the following (Excel 2000 on NT Ver 4) -

Select your cell containing 030109
Select Data Tool
Text to columns
Other and put a / in the blank box
Select Next
Advanced
With 030109 highlighted
Select Date in the format options
Select DMY from the drop down list
Finish

HTH

Bernard
Sorry Fairwinds I didn't mean to "Butt In".

 

[owendodd]

Many thanks for the help!It work fine!