After excel is opened, the number format becomes the currency fo

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. Set cell format to text. Whatever you enter is what you want.

3. 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.

4. Keep an excel instance, delete some strange symbols in the custom format... What is it? I forgot...

5. The solution of setting cell format as normal in Excel, but inputting decimal is automatically converted to currency format is as follows:

1. Right click on the separate cell to be set,
2. Select "set cell format" in the pop-up menu
3. Select "number" in the dialog box
4. Input after the number and decimal: 2, Click the mouse before using the thousand separator to change to the checked status
5. Click OK
after setting in this way, the problems encountered can be solved.

6. This is the problem of setting up. Proceed as follows; After opening excel, right click Select; Set cell format --
select; Number selection; General - click OK to restore.

7. No, regular numbers are going to be like this
is your computer a local language
look at the settings

8. If you're sure it was saved at that time. See if there is macro code in the table, or if it is poisoned.

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.

10. It is estimated that the suffix of your saved file is. XLS! If so, the reason is the compatibility problem of the lower version of Excel
you need to save the set file as a 2007 version of the workbook file with the suffix. Xlsx, so that you can avoid problems
have a try