Excel numbers automatically in currency format

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. Please set the properties of each cell, right-click the cell, select "set cell format", and select the required classification on "number". If you're not wrong, your current cell classification is "currency" in the third attribute.

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. CTRL + Shift + 4, but it can't be used mostly because of input method interference.

8. The method is as follows: open the code page
2, Double click it
3. Select workbook from the left drop-down list and open on the right
4. Add the code below

< / OL >

- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -; If it is not the first table, change 1 to & quot; Change the table name, such as sheets (1) to sheets (& quot; Table name & quot;)< br /> cl = Sheets(1).UsedRange.Find(" Count", , 1).Column
px = Sheets(1).Cells(1, cl).Address
ra = Split(px, "$& quot;)( 1)
Sheets(1).Range(ra & & quot;:& quot; & amp; ra).NumberFormatLocal = "$#,## 0;-$#,## 0"

- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -; Table name & quot;, For example, change sheets (1) to sheets (& quot; Table name & quot;)

9. It may be affected by your operating system
start control panel area and language option area option standard and format [should be Chinese (China)] currency: (should be ￥ 123456789.00) if it is & # 8364; 123456789.00 custom currency symbol, currency positive number format and currency negative number format should be (￥, ￥ 1.1, ￥ - 1.1) respectively.