Prevent Excel from converting 450 to a date?

1

0

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:

  1. Type 450 into cell, it's changed to a date
  2. Clear out the cell
  3. "Format Cells" on the entire column, set to General
  4. Type 450 in again, it becomes a date again

Zeno

Posted 2019-04-19T17:01:10.333

Reputation: 241

4Do you have any worksheet_events that may be forcing the format back to a date on the change of the data in a cell? – Scott Craner – 2019-04-19T17:22:16.477

3Do you have neighbouring cells that are formatted as "date"? That might be an explanation, I have no solution though - other than using "format cells" after the entry. – Hannu – 2019-04-19T21:09:08.180

Answers

0

It's simply because those cells have been formatted as date. After that any input data will be treated as date

To fix just select the cells, right click on them and select "Format cells" (or press Ctrl+1) and choose the Category as General or Number

Format cells

phuclv

Posted 2019-04-19T17:01:10.333

Reputation: 14 930

As indicated, I've done this. As soon as I type 450 into the cell, it reverts back to a date type. – Zeno – 2019-04-19T17:07:56.373

This doesn't answer the question, which clearly states that the cell has not been formatted as a date. – Blackwood – 2020-01-05T00:20:06.330

Asked: 2019-04-19T17:01:10.333

Viewed: 41 times

Active: 2020-01-04T17:21:06.193