Excel is converting
450 to a date when typing 450 into a cell. The date is
3/25/1901. Why is this, and how can it be prevented?
I formatted the cell, but it reverts to date type every time I type in
450. Even prefixing with a space (
" 450") doesn't solve it.
Here is what I'm trying:
450into cell, it's changed to a date
- Clear out the cell
- "Format Cells" on the entire column, set to General
450in again, it becomes a date again