How to stop excel from changing numbers to date?

Posted on 28-02-2020 , by: admin , in , 0 Comments

How to stop excel from changing numbers to date?

Problem
In the 1st column, 1st row, we put 12/1 and it changes to 12-Jan. In the 1st column, 2st row, we put 12-1 and it changes to 12-Jan.

Question
How do I stop this from happening?

Solution(step by step)
Select cells that needs to be filled with 12/1 and 12-1. On higlighted cells click right-click. Next go to Format cells… Under the Number bar, look into the Category selection Set Text as selection, and then Ok.
1 2
Number->Date Number->Number
12-Jan 12/1
12-Jan 12-1

Example:

Put inside the table 1, “6/1” and “6-1”. If it looks like a Table 2, you’ve resolved the solution, and it will be written TRUE. Otherwise it is going to stay at FALSE so you should read again, and go step by step through solution.
TABLE 1 TABLE 2
6/1 FALSE
6-1 FALSE

Leave a comment