Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Weird format to formula transition excel 2003
When entering a date into a cell even after changing the format to Date
format, excel is viewing my entry as a formula. Here's my process: I choose format cells, date, okay. enter 10/19/06 display shows 1/0/1900 cell display shows =10/19/6 I've chosen multiple date formats with the same result. Ideas? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Weird format to formula transition excel 2003
Are you entering an "=" (or a "+") first? If so, excel is processing
=10/19/6 as 10 divided by 19 divided by 6. Try entering: 10/19/06 with nothing before the 10 (if you are entering 2006 dates, you can just enter 10/19 and excel will fill in the rest.) "Macnutt" wrote: When entering a date into a cell even after changing the format to Date format, excel is viewing my entry as a formula. Here's my process: I choose format cells, date, okay. enter 10/19/06 display shows 1/0/1900 cell display shows =10/19/6 I've chosen multiple date formats with the same result. Ideas? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Weird format to formula transition excel 2003
MaNutt
See answer in excel.misc No need for multi-posting......all regulars monitor all Excel groups. Gord Dibben MS Excel MVP On Thu, 19 Oct 2006 11:49:01 -0700, lk wrote: Are you entering an "=" (or a "+") first? If so, excel is processing =10/19/6 as 10 divided by 19 divided by 6. Try entering: 10/19/06 with nothing before the 10 (if you are entering 2006 dates, you can just enter 10/19 and excel will fill in the rest.) "Macnutt" wrote: When entering a date into a cell even after changing the format to Date format, excel is viewing my entry as a formula. Here's my process: I choose format cells, date, okay. enter 10/19/06 display shows 1/0/1900 cell display shows =10/19/6 I've chosen multiple date formats with the same result. Ideas? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 sum figures without formula | Excel Worksheet Functions | |||
Excel 2003 Insert Picture changes JPG to PNG format | Excel Discussion (Misc queries) | |||
Excel 2003 Inserted pictures formatted in PNG format. | Excel Discussion (Misc queries) | |||
TRYING TO SET UP EXCEL SPREADSHEET ON MY COMPUTER | New Users to Excel | |||
Excel 2003 row height format | Excel Discussion (Misc queries) |