How to stop Excel from changing numbers to dates

2 minute read

Home » How To » How to stop Excel from changing numbers to dates

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.

How can Users Stop Excel Changing Numbers to Dates?

1. Convert the Cell Formatting to Text

  1. Users can stop Excel converting numbers to date formats by changing the category for the Excel cells to text. To do that, select the range of cells that will include the numbers by holding the left mouse button and dragging the cursor over them.Cell range selection stop excel from changing numbers to dates
  2. Right-click within the selected cell range and select the Format Cells option, which opens the window in the snapshot directly below.The Format Cells window stop excel from changing numbers to dates
  3. Select Text on the Number tab.
  4. Then click the OK button.
  5. Now 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.
  6. To change the cell format for a whole spreadsheet, click the square at the top left corner of the sheet shown directly below. Then right-click, select Format Cells, and click Text.The Select All button stop excel from changing numbers to dates
  7. Users can also change spreadsheet cell formats by clicking the number drop-down menu on the Home tab shown directly below. Select Text on that drop-down menu.

The number format drop-down menu stop excel from changing numbers to dates


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

Alternatively, users can stop Excel 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.

A fraction entered in Excel stop excel from changing numbers to dates

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.

RELATED ARTICLES TO CHECK OUT: 

Discussions

Next up

Scroll bar is missing in Chrome on Windows 10 [FIX]

Alexandru Voiculescu By: Alexandru Voiculescu
2 minute read

Google Chrome is the most popular browser out there. It is a reliable tool to surf the Internet and has many great features. However, nothing […]

Continue Reading

What to do when your Uplay achievements are not syncing

John Taylor avatar. By: John Taylor
2 minute read

Uplay is an amazing game distribution platform created by Ubisoft. It can be used to buy and download games as well as DLCs. It can […]

Continue Reading

FIX: Ubisoft server unavailable

John Taylor avatar. By: John Taylor
2 minute read

The market is filled with game distribution platforms like Steam, Epic Games Store or GOG. As such, some gaming giants have decided to build their […]

Continue Reading