Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formatting Dates in Excel
When I try to enter a date in my spreadsheet such as 02022007 (02/02/2007)
and hit enter it inputs 09/12/1956???? I have no idea where this value comes from. Is there a place where values for formats can be changed? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formatting Dates in Excel
Dates must be entered as 02/02/2007 or 02-02-2007.
"smithshouse" wrote: When I try to enter a date in my spreadsheet such as 02022007 (02/02/2007) and hit enter it inputs 09/12/1956???? I have no idea where this value comes from. Is there a place where values for formats can be changed? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formatting Dates in Excel
The problem isn't formats, it's XL's input parser that can't guess when
02022007 is a date and when it's representing, say, $2,022,007.00. You can use an event macro to change is behavior. http://cpearson.com/excel/DateTimeEntry.htm Note that your intent in your example (02/02/2007) is ambiguous - mm/dd/yyyy or dd/mm/yyyy? In article , smithshouse wrote: When I try to enter a date in my spreadsheet such as 02022007 (02/02/2007) and hit enter it inputs 09/12/1956???? I have no idea where this value comes from. Is there a place where values for formats can be changed? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formatting Dates in Excel
As others have pointed out, you need to enter the date in date format, but
I'm worried about your Excel. 02022007 should give 24th January 7436, not 09/12/1956. 09/12/1956 should come from 20798 or 20710, depending on your date formatting. -- David Biddulph "smithshouse" wrote in message ... When I try to enter a date in my spreadsheet such as 02022007 (02/02/2007) and hit enter it inputs 09/12/1956???? I have no idea where this value comes from. Is there a place where values for formats can be changed? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Weird Excel date formatting problem | New Users to Excel | |||
Excel changing number formatting and source data in graphs on it's own!!! | Excel Discussion (Misc queries) | |||
Excel 2003 Trashes Imported Dates | Excel Discussion (Misc queries) | |||
Excel error - remove some formatting | Excel Discussion (Misc queries) | |||
Conditional Formatting in Excel Help Please..... | Excel Discussion (Misc queries) |