How to enter a currency number with a plus sign
Publish: 2021-03-31 21:24:34
1.
1. The computer opens the excel table and selects the data to be marked with currency
2. You can choose one of the following:
1. Set the cell format to "text" first, and then you can enter it freely
2; As input lead (that is, input it first), and then input data.
1. Set the cell format to "text" first, and then you can enter it freely
2; As input lead (that is, input it first), and then input data.
3. Press and hold the corresponding currency symbol on the keyboard to pop up more options, and then slide to select the currency symbol you want to enter. The default symbol is the same as the keyboard you are currently using. For example, for simplified Chinese input method, the default symbol is ￥.
4. It can be input with word, not with computer and mobile phone
5. To input the number with RMB or US dollar currency symbol, you can input it directly through the keyboard. The operation method is as follows:
6.
How to input currency symbol in Excel cell:
-
input currency symbol first and then number directly in cell
-
select the cell range to input currency, right-click, click "set cell format" in the shortcut menu, and select the display mode of "number" -- "currency" -- "currency symbol" -- "decimal digits" -- "negative number"
In the first method, you need to input the currency symbol every time, but you can have a flexible number form, which can be displayed as an integer or two decimal places. In the second method, you only need to input the number directly, and you don't need to input the currency symbol, but you need to determine the decimal places in advance, All are displayed in this decimal place
7. =sum(--A1:D1)
CTRL+SHIFT+ENTER
三键结束测试[UNK]
CTRL+SHIFT+ENTER
三键结束测试[UNK]
Hot content