| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Tracking history of Office files chronologically | Excel Discussion (Misc queries) | |||
| Please...need help setting up loss run history for claims tracking | Excel Discussion (Misc queries) | |||
| Tracking inventory order history | Excel Discussion (Misc queries) | |||
| Convert alphanumerical(eg. 12.11.2005) to date as 12-Nov-2005 in e | Excel Discussion (Misc queries) | |||
| chnage date from tuesday 4 January 2005 10:39.26 to 04/01/2005 | Excel Worksheet Functions | |||
Threaded Mode
