How to make numbers without currency symbols
Publish: 2021-03-22 11:45:42
1. Right click & quot; Format Cells & quot-& gt;“ Select currency for the category of number tab and none for currency symbol (top 1)
2. It may be that you have defined the format. You can select the cell, right-click to set cell format, number and have a look
3.
Required raw materials: 2016 excel
method of adding and deleting currency symbol in Excel:
-
select the content of currency symbol to be added in the excel document
-
right click to select cell format, and select currency in the number (no need to select none)
< / OL >
4. For example, if you want to enter "1000" in a cell, then you can select the cell with your mouse, right-click "set cell format" and select "currency" under the category of "number", and then you will see "decimal digits", "currency symbol" and other options on the right, You can choose the symbol you need!
5. This is the currency format of Excel. To remove it, just follow the following steps:
select these cells → format → cells → numbers → general (or numerical value, and specify decimal places) → OK
if you don't set the currency format, ¥ is entered manually, you can use the method above.
select these cells → format → cells → numbers → general (or numerical value, and specify decimal places) → OK
if you don't set the currency format, ¥ is entered manually, you can use the method above.
6.
1. The computer opens the excel table and selects the data to be marked with currency
7. Directly select the amount part and click "U (underlined)" after "Toolbar" - Format "is opened. If format is on, bold & quot; B "on the right is this key.
8. If the currency symbol is displayed by setting the cell format, reset the format to remove it
if all are manually entered, you can search and replace with blank.
if all are manually entered, you can search and replace with blank.
9. In this cell, right-click to set cell format, select currency format, and enter 0 to display "¥ 0".
10. Set the cell format, change #, #, 0.00 to #, #, 0.00 ¥ in user-defined, and then set the cell to this format
Hot content