| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
DATE FORMATTED COLUMN ERROR
WHY IS MY DATE FORMATTED COLUMN SHOWING A FIVE DIGIT NUMBER? Eg: 24-Nov-04 is
showing as 38317 |
|
#2
|
|||
|
|||
|
Hi Gveames,
WHY IS MY DATE FORMATTED COLUMN SHOWING A FIVE DIGIT NUMBER? 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. --- Regards, Norman "gveames" wrote in message ... WHY IS MY DATE FORMATTED COLUMN SHOWING A FIVE DIGIT NUMBER? Eg: 24-Nov-04 is showing as 38317 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Automatically enter date and time but only update once. | New Users to Excel | |||
| What formula do I use to add to a date column in Excel? | Excel Discussion (Misc queries) | |||
| Combine candle and line in a single chart | Charts and Charting in Excel | |||
| Format an excel column as a date for a 5 day week for a year. | Excel Discussion (Misc queries) | |||
| How do I format column containing date and time to only show the . | Excel Discussion (Misc queries) | |||
Linear Mode
