Excel number setting currency default

1.

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

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

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

4. After opening the file form, select the cell that needs to set currency, there is a format option in the upper right corner of the form, which can be set as currency. If you don't understand, please leave a message and ask. Thank you!

5. This is just a matter of setting the cell format.
1. Select the box where the value is said to be in,
2. Right click to find the setting cell format bar,
3. Click to enter, and then click the value or general in the option box,
4. OK to restore the value.

6. Right click the cell and select Format cell. Select the number tab in the pop-up window. Select currency in the window. After selection, you can set decimal places and currency symbols in the window on the right. After setting, click OK to finish setting.

7. Set cell format - number - currency - currency symbol, select US dollar

8. Menu - Format - cell - number - currency

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