G Guest Nov 26, 2004 #1 WHY IS MY DATE FORMATTED COLUMN SHOWING A FIVE DIGIT NUMBER? Eg: 24-Nov-04 is showing as 38317
N Norman Jones Nov 26, 2004 #2 Hi Gveames, WHY IS MY DATE FORMATTED COLUMN SHOWING A FIVE DIGIT NUMBER? Click to expand... Excel stores dates as a serial number derived from the number of days elapsed since the beginning of 1900. To convert the serial numbers to visual date representations,. try formatting the relevant cells with a date (or custom) format.
Hi Gveames, WHY IS MY DATE FORMATTED COLUMN SHOWING A FIVE DIGIT NUMBER? Click to expand... Excel stores dates as a serial number derived from the number of days elapsed since the beginning of 1900. To convert the serial numbers to visual date representations,. try formatting the relevant cells with a date (or custom) format.
