Date Formatting
 

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

Date Formatting
 

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

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

Date Formatting
 

Do you want 11163 displayed as 11/1/63 or 1/11/63
--
Gary''s Student - gsnu200779


"theresa317" wrote:

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

Date Formatting
 

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

"Gary''s Student" wrote:

Do you want 11163 displayed as 11/1/63 or 1/11/63
--
Gary''s Student - gsnu200779


"theresa317" wrote:

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