How can I convert a date in format DDMMYY to DD/MM/YYYY in Excel 2002.
Thanks
Steve.
Share
Computing.net: Question & Answers Forum
Lost your password? Please enter your email address. You will receive a link and will create a new password via email.
How can I convert a date in format DDMMYY to DD/MM/YYYY in Excel 2002.
Thanks
Steve.
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