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? |
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) |