The number in the table cannot be formatted

1.

The number in excel is changed into currency "#" format mostly e to the use of other formats, which can be changed back to numerical value or conventional. The specific steps are as follows:

required materials: Excel

First, open the excel file and select the number cell in currency format

2.

The reason for this phenomenon is that there is a problem in the setting. The specific solutions are as follows:

1. First, create a new excel document

3. Set cell format to text. Whatever you enter is what you want.

4.

Tools: word software

1. First, use Excel to open the prepared worksheet, open the cell of setting currency format, and select the "number" option in the start tab< br />

5.

Here is an operation flow of word number to currency format:

required materials: this method is only applicable to the numbers in the table

1. As shown in the figure below, the numbers are listed on the left. Click the first cell on the top right to enter the "layout" menu

6. Bus stop - Longgang Central Hospital Station
bus: No. 309; 351 road; 353 road; 380A line; 802 channel; 810 road; 811 road; 839 road; 862 road; M275 road; M276 road; M279 road; M280 road; M296 road; M307 road; M308 road; M316 road; M386 road; Shenhui line 1

if it's not too far away, take a seat in Shuanglong, and then go north for a section

7.

-

it's very simple! Two steps

Step 1: set cell format to currency format, as shown in the following figure

8. Just input
= A1
directly. Why & & quot& quot;

9. Select a so-called "space" on the edit bar, and edit replace it. Paste the copied "space" in "find content" and click "replace all". In this way, all the "spaces" can be deleted. Generally, after deleting the space, the data of the cell can be summed up. If it is still in text format, You need to change the cell format to regular or numeric. Generally use the method of column: select column - Data - column - next step, to the third step, select "column data format" as "general" - complete. Then you can sum.

10.

First of all, the number stored in the form of text should be changed into non text number. The method is as follows:

how to directly convert the text into a numerical value

method 1

select cell right click Set cell format change & quot; Text & quot; Is & quot; General & quot; Format - enter the cell and press enter to confirm. If a large number of cells are values in text format, enter the cell one by one and press enter to confirm, So it is very inconvenient.

method 2

select an empty cell - right click - - and then select the cell and cell range where the text format is located - right click - selective paste - add - confirm. This is the way to add 0 to the selected cell or cell range by operation, so as to turn it into a regular number.

method 3

select text The cell or cell range where the format value is located - an option icon will appear next to the selected cell or cell range - click to open the options menu - Select & quot; Convert to number & quot