| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
The way the date displays in columns
We have a huge spreadsheet containing various pieces of information about
files. One of the columns contains a date. The column is formatted as Date. However, for some inexplicable reason the date in this column is now showing as just digits. If you double click on the cell it displays the date as it should be seen, i.e. 40634 = 01/04/2011 37834 = 01/08/2003 37926 = 01/11/2003 Can anyone explain why, please. Also, it doesn't matter how I format that particular column it refuses to display the date as a date. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula for determining if two date columns fall within specific date range | Excel Worksheet Functions | |||
| Formula for determining if two date columns fall within specific date range | Excel Discussion (Misc queries) | |||
| date in Excel displays incorrectly when merged in letter | Excel Discussion (Misc queries) | |||
| Calculate 1st of month date from existing date. | Excel Discussion (Misc queries) | |||
| set a date in columns 7 days apart | Excel Worksheet Functions | |||
Threaded Mode
