Change the number in the cell to text format

Select all text and number cells to be modified, select "data"> "data" (for example) in the Excel menu)

 

 

 

 

 

 

 

The following dialog box is displayed:

 

 

 

 

 

 

 

 

Choose "Next"> "Next"> "normal" as the column data format. (For example)

 

 

 

 

 

 

 

In the preceding method, if you want to convert the number format to a number in text format, select "text" as the column data format in the last step.

 

 

 

In addition, when Excel is used, do we find that when you click a cell in text format, there is an exclamation point (such as) in the upper left corner of the cell)

 

 

 

 

 

 

 

 

It can also help us convert numbers in the text format to numbers in the regular format? How to apply it? Let's take a look!

 

 

 

1. When the mouse points to the small box, a Down Triangle appears, which is a drop-down menu.

 

 

 

 

 

 

 

 

2. Click the triangle and select "converted number" from the drop-down menu.