| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Date formatting error
I have a spread sheet that has a column for dates - formatted for dates-
In some cells, when I enter 8/1/09 it turns it into a formula and gives me 1/0/1900. I've tried deleting, erasing, everything! Please help. thanks! ckt |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Date formatting error
Tools/Options/Transition, deselect Transition formula Entry.
"Cindyt" wrote in message ... I have a spread sheet that has a column for dates - formatted for dates- In some cells, when I enter 8/1/09 it turns it into a formula and gives me 1/0/1900. I've tried deleting, erasing, everything! Please help. thanks! ckt |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| conditional formatting for cell date to equal today's date | Excel Worksheet Functions | |||
| Date Formatting Error | Excel Discussion (Misc queries) | |||
| "Excel encountered an error and had to remove some formatting toavoid corrupting the workbook. Please re-check your formatting carefully." | Excel Discussion (Misc queries) | |||
| Excel 2003: Error with date formatting | Excel Discussion (Misc queries) | |||
| date formatting error | Setting up and Configuration of Excel | |||
Linear Mode
