software

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 quot;/quot;
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.quot;mddyyyyquot;)

--

Regards,

Peo Sjoblom

Northwest Excel Solutions

www.nwexcelsolutions.com

(remove ^^ from email address)

Portland, Oregon

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

quot;Peo Sjoblomquot; wrote:

gt; If you want to display it as mddyyy use custom format, if you want to change
gt; the underlying date serial to a number thus the serial date of 11/11/2006
gt; which is 39032 into the number
gt; 11112006
gt;
gt; =--TEXT(A1.quot;mddyyyyquot;)
gt;
gt; --
gt;
gt; Regards,
gt;
gt; Peo Sjoblom
gt;
gt; Northwest Excel Solutions
gt;
gt; www.nwexcelsolutions.com
gt;
gt; (remove ^^ from email address)
gt;
gt; Portland, Oregon
gt;
gt;
gt;
gt;
gt; quot;Georgequot; gt; wrote in message
gt; ...
gt; gt; Hi,
gt; gt; I need some help changing the date format in xls.
gt; gt; I have the following U.S date format = 02/21/2006.
gt; gt; I need to convert this into 2212006, = mddyyyy
gt; gt; I.e drop the zero and drop the quot;/quot;
gt; gt; i have tried a number of techniques but there seems to be a problem when i
gt; gt; get
gt; gt; to dates such as 11/11/2005, = mmddyyyy
gt; gt; Thanks
gt; gt; George
gt;
gt;