How to Stop Excel from Changing Numbers to Dates [TESTED]

2 tested methods to stop Excel changing to date ✅

2 min. read

Updated onOctober 4, 2023

updated onOctober 4, 2023

Share this article

Improve this guide

Read our disclosure page to find out how can you help Windows Report sustain the editorial teamRead more

Key notes

Excel users often enter values that include slashes (/) for fractions or hyphens (-) for number ranges in cells. For example, some users might enter 1/2 (for half fractions) or 8-19 (for a numeric range).

However, Excel automatically formats values entered with slashes or hyphens to the date format. Thus, the software converts 1/2 to 2-Jan and 8-19 to 19-Aug.

Why does Excel keep changing my numbers to dates?

This occurring issue can appear on Excel sheets because the program has automatic converting rules that can change all your numbers into dates.

For instance, if you insert numbers in a cell like 3/6/2000, it will be transformed into a date due to its format, changing the value as well.

How to stop Excel from converting to date?

1. Convert the cell formatting

Users can stop Excel converting numbers to date formats by changing the category for the Excel cells to text. This can be easily done through the app’s built-in settings.

Open Microsoft Excel.
Select the range of cells that will include the numbers by holding the left mouse button and dragging the cursor over them.

3.Right-click within the selected cell range and select theFormat Cellsoption.

SelectTexton theNumbertab.
Then click theOKbutton.

6.To change the cell format for a wholespreadsheet, click the square at the top left corner of the sheet shown directly below.

7.After, right-click on it and selectFormat Cells, then onText.

Users can also change spreadsheet cell formats by clicking the number drop-down menu on the Home tab shown directly below. SelectTexton that drop-down menu.
Now you can enter the numbers in the text format cells. Excel will not convert any fractional values, such as 1/2, entered in the text cells to dates.

2. Enter a Space or Apostrophe (‘) Before the Numbers to prevent the conversion

Alternatively, users can stop Excel from converting numbers to dates by adding a space or apostrophe when entering numbers.

For example, instead of entering 1/2 in a spreadsheet cell, enter ‘1/2 in the cell instead. The cell will then display the fraction without any apostrophe as in the shot directly below.

Users can also enter a space before the number to ensure Excel doesn’t convert it to date. However, the cell will still include the space entered. The number will become a fractional number in the spreadsheet cell when users enter a 0 and a space before the fraction.

So, that’s how users can ensure Excel doesn’t convert numbers to dates. Then users can enter slashes and hyphens in cells for fractional numbers and numeric ranges.

We hope you found this article useful and that it helped fix your Excel issue.

How to Stop Excel from Changing Numbers to Dates [TESTED]#

Why does Excel keep changing my numbers to dates?#

How to stop Excel from converting to date?#

1. Convert the cell formatting#

2. Enter a Space or Apostrophe (‘) Before the Numbers to prevent the conversion#

How to Stop Excel from Changing Numbers to Dates [TESTED]

Why does Excel keep changing my numbers to dates?

How to stop Excel from converting to date?

1. Convert the cell formatting

2. Enter a Space or Apostrophe (‘) Before the Numbers to prevent the conversion