How to Stop automatically changing numbers to dates in excel?


QuestionsCategory: Computer & InternetHow to Stop automatically changing numbers to dates in excel?
Anonymous asked 4 years ago

Microsoft Excel is pre-programmed to make it easier to enter dates. For example, 12/2 changes to 2-Dec. This is very frustrating when you enter something that you don’t want changed to a date. Unfortunately there is no way to turn this off.Kindly help me out

1 Answers
Ankush Mehrotra Staff answered 4 years ago

Preformat the cells you want to enter numbers into as Text. This way Excel will not try to change what you enter into dates.

  1. Select the cells that you’ll enter numbers into.
  2. Press Ctrl + 1 (the 1 in the row of numbers above the QWERTY keys) to open Format Cells.
  3. Select Text, and then click OK.

If you only have a few numbers to enter, you can stop Excel from changing them into dates by entering:

  • A space before you enter a number. The space remains in the cell after you press Enter. (See Notes)
  • An apostrophe (‘) before you enter a number, such as ’11-53 or ‘1/47. The apostrophe isn’t displayed in the cell after you press Enter.
  • A zero and a space before you enter a fraction such as 1/2 or 3/4 so that they don’t change to 2-Jan or 4-Mar, for example. Type 0 1/2 or 0 3/4. The zero doesn’t remain in the cell after you press Enter, and the cell becomes the Fraction number type.
Your Answer

4 + 10 =