Format cell numbers as currency

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

3.

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:

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

5. If the data is in column a, you can enter the formula in B1:
= replace (A1, match (, 0 / mid (A1, row ($1): $99), 1),,, & quot; ￥")
press Ctrl + Shift + enter to end the formula, and then drop it down

6.

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 />

7.

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

8.

Method:

1. Open excel table and select the cell to be set as currency format

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

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