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