Date Formatting

  • Thread starter Thread starter theresa317
  • Start date Start date
T

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
 
=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:
 
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
 
Back
Top