Change date format

[George]

Hi,
I need some help changing the date format in xls.
I have the following U.S date format = 02/21/2006.
I need to convert this into 2212006, = mddyyyy
I.e drop the zero and drop the "/"
i have tried a number of techniques but there seems to be a problem when i get
to dates such as 11/11/2005, = mmddyyyy
Thanks
George

 

[Peo Sjoblom]

If you want to display it as mddyyy use custom format, if you want to change
the underlying date serial to a number thus the serial date of 11/11/2006
which is 39032 into the number
11112006

=--TEXT(A1."mddyyyy")

--

Regards,

Peo Sjoblom

Northwest Excel Solutions

www.nwexcelsolutions.com

(remove ^^ from email address)

Portland, Oregon

 

[George]

looks good thanks very much

If you want to display it as mddyyy use custom format, if you want to change
the underlying date serial to a number thus the serial date of 11/11/2006
which is 39032 into the number
11112006

=--TEXT(A1."mddyyyy")

--

Regards,

Peo Sjoblom

Northwest Excel Solutions

www.nwexcelsolutions.com

(remove ^^ from email address)

Portland, Oregon