Excel number into currency

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. Select all the tables, and then Ctrl + Shift + ~ should be OK. The last symbol is the wave sign. Try it

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

5.

To convert a number to a currency number is to set the value cell format to currency format. The following steps are as follows:

1. select the cell to be set, right-click to select the cell format

2. to open the cell Format dialog box, click the number tab (the general default number tab is activated)

3. to select the currency symbol and decimal point according to your own needs, Then determine the specific recording operation of

< / OL >

as shown in the following figure:

6. If you mean that a cell in regular format will change to currency format after entering a number, please try the operation:
1. If the number is pasted, please select the value "123" in
"paste special"
2. If the number is manually entered, please right-click the cell containing the number, Set the cell format, select "general"
or select the cell containing numbers, and then click Ctrl +! Shortcut key, you can quickly open the cell Format dialog box, select "general" or other data types you need.

7. Tengjia enamel steel water tank is to use HSC series enamel as base glaze and surface glaze δ 2- δ 5. A new type of water tank is assembled by firing plates on enamel.
Tengjia stainless steel water tank is commonly used as stainless steel fire water tank, and the square combined water tank is made of SUS304 and stainless steel plate, which is formed by stamping.

8. Format - & gt; Column - & gt; Column width --- enter a large number to see
if you can't, then format --- row --- row height --- enter a large number to see

9. Select all the tables and press Ctrl + 1 to set the data type to normal

10. Because the cell width is not enough, it will be displayed when it is elongated
let's see what others say.