Add "/" to a date string

  • Thread starter Thread starter bpc
  • Start date Start date
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.
 
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?
 
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
 
Back
Top