View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] rmosko@colpenn.com is offline
external usenet poster
 
Posts: 2
Default 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