Hide currency symbols and display numbers

1. Right click & quot; Format Cells & quot-& gt;“ Select currency for the category of number tab and none for currency symbol (top 1)

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

3. Word pure blank file is not good, to be able to operate under the spreadsheet to display currency figures, otherwise you have to type a few decimal places. You can insert a spreadsheet in word (it's not good to insert a spreadsheet either) in the shortcut toolbar insert a spreadsheet enter the number you want select the cell you want to change right click Set cell format number currency change the number of decimal places you want to keep. Or directly use Excel (electronic form) to operate the same as above, right-click the cell to be transformed, and click Set cell format - number - currency - OK. Now the next version of WPS 2010, the function is also very good yo. Give the owner a WPS download link: http://xiazai.zol.com.cn/detail/9/88682.shtml If you have time to be familiar with the WPS operation, it will bring you a lot of convenience.

4. Set the cell format to normal
and then select these numbers and click the exclamation mark to convert the text to a numerical value.

5.

Select area - right click - set cell format - switch to number tab - select value by category - select negative number format - OK, as shown in the figure:

6. Select the cell where you want to input currency symbol, and right-click - set cell - number - currency (select the currency symbol you want)
after this setting, you do not need to input currency symbol any more, you can input number directly to display both currency and number.

7. Currency number format is only applicable when the data in excel2010 cell is currency number. The specified currency symbol will be added to the cell set to currency number format. The steps to format currency numbers in Excel 2010 are as follows: http://jingyan..com/article/359911f516953d57fe0306e1.html