In History sheet (tracking changes), date (in column B) is 38,666 (instead of 11/10/2005)
I'm using Excel 2003 SP2 under WinXP SP2, and I recently enabled "Track
Changes" - with changes listed in the "History" sheet - in one of my
spreadsheets. This is my first experience with Change Tracking in
Excel.
The problem: in the Date column of the History sheet, the dates are
displaying as numbers (for example, "38,666") instead of dates
(...should be "11/10/2005"). Since the sheet is protected, I can't
change the cell formats.
Has anyone else seen this? Is there a solution?
Rory Mosko
|