H
Happy One
How to change the number 1122008 to 1/12/2008?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
F
Fred Smith
Probably the best is:
=date(mod(a1,10000),mod(int(a1/10000),2),day(int(a1/1000000)))
This will handle the case where you have two digit dates.
Regards
Fred
=date(mod(a1,10000),mod(int(a1/10000),2),day(int(a1/1000000)))
This will handle the case where you have two digit dates.
Regards
Fred
D
David Biddulph
=DATE(RIGHT(A2,4),MID(A2,LEN(A2)-5,2),LEFT(A2,LEN(A2)-6))
D
Dave Peterson
This worked for me with my USA date settings (mdy):
=--TEXT(A1,"00\/00\/0000")
and formatted as a date
=--TEXT(A1,"00\/00\/0000")
and formatted as a date
H
Happy One
Yes, it works.
Thank you,
Thank you,
Dave Peterson said:This worked for me with my USA date settings (mdy):
=--TEXT(A1,"00\/00\/0000")
and formatted as a date