Need help with date format !
 

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

Need help with date format !
 

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.

"pkucan" wrote in message
...
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

Need help with date format !
 

Use a customer format:

mm/dd/yyyy

HTH,
Paul

"pkucan" wrote in message
...
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

Need help with date format !
 

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

mm/dd/yyyy

Regards,
Paul

"PCLIVE" wrote in message
...
Use a customer format:

mm/dd/yyyy

HTH,
Paul

"pkucan" wrote in message
...
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