Quote: Originally Posted by chris314159
Doing this will completely mess your excel files. (At least for 2003). All my date formats are changed and when I enter new dates it doesn't recongnize the formatting anymore.
You could change your date & time format directly in your cell
Select the cell, format, date, time
Select in the list the output that you want or build yours in the format task bar