Add "/" to a date string
 

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.

Add "/" to a date string
 

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

Hope this helps.
--
John C


"bpc" wrote:

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.

Add "/" to a date string
 

Got it. Thx

"John C" wrote:

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

Hope this helps.
--
John C


"bpc" wrote:

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.

Add "/" to a date string
 

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 BPaste
SpecialValues in column A and delete column B.

Does that help?

"bpc" wrote in message
...
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.

Add "/" to a date string
 

Hi

try marking your columnDataText to columnsNextNextDateM/D/YFinish

--
Regards
Roger Govier

"bpc" wrote in message
...
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.

Add "/" to a date string
 

This also works...

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

--
Rick (MVP - Excel)


"bpc" wrote in message
...
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.

Add "/" to a date string
 

On Fri, 5 Sep 2008 09:24:01 -0700, bpc wrote:

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.

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

--ron