Position: Home page » Currency » How to make numbers without currency symbols

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:

  1. select the content of currency symbol to be added in the excel document

  2. right click to select cell format, and select currency in the number (no need to select none)

  3. < / 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.
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.
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
Inn digger Publish: 2021-05-29 20:04:36 Views: 341
Purchase of virtual currency in trust contract dispute Publish: 2021-05-29 20:04:33 Views: 942
Blockchain trust machine Publish: 2021-05-29 20:04:26 Views: 720
Brief introduction of ant mine Publish: 2021-05-29 20:04:25 Views: 848
Will digital currency open in November Publish: 2021-05-29 19:56:16 Views: 861
Global digital currency asset exchange Publish: 2021-05-29 19:54:29 Views: 603
Mining chip machine S11 Publish: 2021-05-29 19:54:26 Views: 945
Ethereum algorithm Sha3 Publish: 2021-05-29 19:52:40 Views: 643
Talking about blockchain is not reliable Publish: 2021-05-29 19:52:26 Views: 754
Mining machine node query Publish: 2021-05-29 19:36:37 Views: 750