Change date format

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
 
looks good thanks very much

Peo Sjoblom said:
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
Click to expand...
 
Back
Top