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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Cell Format Defaults to a Formula
In xl2003 menus, try:
Tools|Options|Transition tab Uncheck all those Lotus 123 settings. Excel is seeing your entry as 3 divided by 17 divided by 2008. A very small number that would be on Jan 1, 1900 when you format it as a date. Desoto wrote: 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 -- Dave Peterson |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Cell Format Defaults to a Formula
Many thanks Dave. I will try that first thing in the morning when I get in
the office. I have worked with Excel for 15 years and had never come across that issue. Desoto "Dave Peterson" wrote: In xl2003 menus, try: Tools|Options|Transition tab Uncheck all those Lotus 123 settings. Excel is seeing your entry as 3 divided by 17 divided by 2008. A very small number that would be on Jan 1, 1900 when you format it as a date. Desoto wrote: 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 -- Dave Peterson |
Reply |
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) |