Add "/" to a date string

B

bpc

I have dates of birth entered into a column as 41384 which I would like to
insert the "/" symbol so that the dates read 4/13/84. The month never
includes a leading zero (4 for April not 04), however the day of month always
does.
 
J

John C

=DATE(RIGHT(A1,2),LEFT(A1,1+(LEN(A1)=6)),MID(A1,2+(LEN(A1)=6),2))

Hope this helps.
 
G

Gaurav

with your date in A1.. try the following formula in B1

=LEFT(A1,1)&"/"&MID(A1,2,2)&"/"&RIGHT(A1,2)

Drag it down as far as needed and then you can copy column B>Paste
Special>Values in column A and delete column B.

Does that help?
 
R

Roger Govier

Hi

try marking your column>Data>Text to columns>Next>Next>Date>M/D/Y>Finish
 
R

Ron Rosenfeld

I have dates of birth entered into a column as 41384 which I would like to
insert the "/" symbol so that the dates read 4/13/84. The month never
includes a leading zero (4 for April not 04), however the day of month always
does.
Click to expand...

=TEXT(A7,"0\/00\/00")

--ron
 
Top