Need help with date format !

P

pkucan

I have a multitude of dates in the format i.e. 2/8/1988
All my dates must be 10 digits i.e. 02/08/1988
Have tried all canned formating and none work
Thanks
 
G

Guest

Hi

Have to tried Data / Text to columns?
Select the column first and on the thrid dialog box of the wizard, there is
an option to tell Excel that the info is a date.
Make a backup before you start!

Andy.
 
P

PCLIVE

Oops! What's a "customer" format. That should be "custom" format.

mm/dd/yyyy

Regards,
Paul
 
Top