How to enter numbers in Excel so that they display the corresponding text

I want to enter numbers in the same 1 cell.

It's not okay to display text, but it can be done.

Enter numbers in box A1 and text in box A2.

For example, in self. a1

cell.

1", after the input is completed, a1

The contents of the cell immediately change to a category such as "Student", and this effect must be programmed.

However, if in.

a1.

1", for example, in another cell.

b1 shows "China", this can be passed.

vlookup

The formula is realized, in.

e3: In the F5 area, a list of "Code" and "Category" is predefined; Then in the actual input area, in the "Category" cell for example.

B3:

vlookup(a3,$e$3:$f$5,2) a3

Enter "1" in.

B3 automatically displays the "Learner", which comes from the predefined data in the E3:F5 region. As shown below:

Alternatively, it can be accessed through the "Data Validity.

to enforce data validity restrictions on the cells to display predefined content. When you enter this column of cells, a drop-down list will appear on the right side of the cell, with predefined items to choose from. As shown in Fig

I want to enter numbers in the same cell.

Displaying text is not a no-no.

It can be done. Enter numbers in box A1 and text in box A2.

The simplest example, ** number query, A1 grid input.

**, A2 box display.

The name of the contact.

There are 2 ways to implement it, and method 1 is utilized.

if function: In.

A2 input.

ifa1="Number 1", Contact 1",if(a1="Number 2", Contact 2",if(a1="Number 3","Contact 3",.."This number is not found")

This formula is cumbersome and complicated to modify.

Method 2: Make use of the vlookup function.

First of all. To make a list of numbers corresponding to names, number 1

Contact 1 number 2

Contact 2 number 3

Contact 3 assumes this list.

You put it in. b，c

Two columns, from B1, C1 to.

b100，c100

i.e. 100 numbers).

Then in the A2 position, type:

vlookup(a1,$b$1:$c$100,2,0). The above 2 methods.

When you're done, enter it at A1.

Digit. Text can be displayed at A2.

1. Enter a number and text comparison table on other tables in advance, and then use the vlookup formula to enter numbers in one column, and the corresponding text will be automatically displayed in the other column.

2. If you want to enter numbers directly into text, you can use "Tool Autocorrect Option".

Enter the formula in the set number.

Use functions. Show the numbers!

Can be used. if() function.

It can also be used with other search functions (i.e. to find tables that correspond to words and numbers) ......

Hello, operation step 1, enter the number to display the corresponding Chinese characters, select the menu bar start tab, select conditional formatting, select new formatting rule, select only for the unit containing the following content to set the format, enter numbers and text 2, conditional formatting automatically add borders, select the menu bar carefully grind the start tab, conditional formatting, new rule, use the formula to determine the cell width grid to be formatted, enter the formula = $a 1>""Then you can add a border to the formatting.

<> sort out the range of numbers, only need to write the minimum value of the range.

lookup(a2,e:e,f:f)

<> the first method: type an English state in the cell first'number, and then enter the number.

<> the second method: click Right Jian - Format Cells - Number - Text - OK.

In cell formatting, the numbers are processed as text, and the content displayed in the cell is exactly the same as the entered content.

Reason 1: If the number exceeds 11 digits, it will become a scientific notation, for example, 123456789789 becomes, and if it exceeds 15 digits, all the digits after 15 digits will become 0, and there are 2 solutions:

First, enter the single quotation marks in the English input state'Then enter the number and it will be displayed normally.

Second: Or select the column or cell first, right-click, [Format Cell.]"Digit. ", [Text.]"and OK. Then enter the number and it will be displayed normally.

Reason 2: If you enter a number in excel, it always becomes a date when you press enter, and the solution is as follows;

Select the cell that needs to be problematic, right-click, and click "Format Cell".

Click on "Numbers".

Find "Text" in its options and click "OK".

How to set a cell to display the corresponding number according to the text of another cell in Excel.

Perform the following operations. 1. First of all, we open the excel in the computer, select a chain cell, and click on the data validity under the data directory. 2. Then we will pop up the interface to allow the following selection sequence, fill in the required selection content above, and separate it with a lowercase comma.

3. Fill in the words and numbers on the other two columns respectively, and the left and right should correspond, here we can fill in the corresponding numbers. 4. Then fill in the formula on the cell you need to change and press enter. 5. Then select the text, and the corresponding number will be automatically displayed in another column.

After the operation of the party chain is completed, the corresponding text can be displayed.