excel change date from dd.mm.yyyy to dd/mm/yy

February 28, 2011 at 05:59:09
Specs: N/A
i have a download from SAP and need to change the dates from dd.mm.yyyy to dd/mm/yyyy so i can use conditional formating on the dates EXCEL 2003

See More: excel change date from dd.mm.yyyy to dd/mm/yy

Report •

#1
February 28, 2011 at 08:43:53
An easy way to do it is just to Ctrl+F, Click 'Replace'. Replace All '.' with '/'. xx.yy.zzzz becomes xx/yy/zzzz.

If you have other periods in the worksheet this will change them as well, so you may have to copy the dates over to a different sheet, fix them, then paste them back in.

Or maybe someone knows a fancy date formatting trick.


Report •
Related Solutions


Ask Question