How to enter numbers as text in Excel

Let’s take a look.

First, let’s look at the problem.

In the case of the part code, Excel actually interprets the code as a date.

The problem is that Excel is treating these values as numbers or dates.

We need a way to tell Excel to treat this input as text.

There are two ways we can do this.

The first way is to use a single apostrophe when entering the values.

This tells Excel to treat the content as text.

Note that we can see the apostrophe in the formula bar when the cells are selected.

However, the apostrophe is not visible in the worksheet.

The second way is to format cells as text before inputting values.

This will cause Excel to treat all input to these cells as text.

Note that with this technique, the formula bar does not show an apostrophe.

you’re free to easily tell Excel to ignore this error.