Date Formatting

[theresa317]

I received a worksheet from someone with the date stated as a number. ie..
100364, 80763. These are actual dates without any formatting(/ -). I need a
formula that will insert a "/". Thanks

 

[Marcelo]

=IF(LEN(D12)=6,LEFT(D12,2)&"/"&MID(D12,3,2)&"/"&RIGHT(D12,2),"0"&LEFT(D12,1)&"/"&MID(D12,2,2)&"/"&RIGHT(D12,2))

Assuming that your data is in D12.

hth
--
regards from Brazil
Thanks in advance for your feedback.
Marcelo



"theresa317" escreveu:

 

[Gary''s Student]

Do you want 11163 displayed as 11/1/63 or 1/11/63

 

[daddylonglegs]

What dates do these represent, assuming October 3rd 1964 and August 7th 1963
and that the day will always have 2 digits then with data in A! you can
convert with

=TEXT(A1,"00-00-00")+0

format as date