| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Cell Format Defaults to a Formula
I have inherited a worksheet constructed by someone else and need to load
dates in a column of cells. Unfortunately when a date of "3/17/2008" is entered into the cell range it displays January 1, 1900. If the cell range is formated to "Date Format" it continues to display January 1, 1900. Can someone please tell me what I am missing here? Thanks in advance? Desoto |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Date format defaults to Custom | Excel Discussion (Misc queries) | |||
| Format Defaults | Excel Discussion (Misc queries) | |||
| Customizing Excel's 'Format Cells' defaults - how? | Excel Discussion (Misc queries) | |||
| Format cells alignment defaults | Setting up and Configuration of Excel | |||
| Picture format defaults in Excel | Excel Discussion (Misc queries) | |||
Threaded Mode
