convert date ddmmyy to dd/mm/yy in excel

November 18, 2010 at 05:15:55
Specs: Windows XP
How can I convert a date in format DDMMYY to DD/MM/YYYY in Excel 2002.

Thanks

Steve.


See More: convert date ddmmyy to dd/mm/yy in excel

Report •

#1
November 18, 2010 at 07:00:32
Your looking for a Custom Format:

On the Format menu, click Cells.
On the Number tab, click Custom from the Category list.
In the Type box overwrite what ever is in there, probably the word General
with:

DD/MM/YYYY

click OK

MIKE

http://www.skeptic.com/


Report •
Related Solutions


Ask Question