How to set the number with currency symbol

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

Take excel 2016 as an example, there are the following steps:

1. Open an excel worksheet, as shown in the figure below:

The operation method of adding currency symbol to cells in excel is as follows:

1. first, select cells (such as m54), right-click the cell range, and select "set cell format"

2. next, click "number" -- "currency", select the corresponding currency symbol, such as "￥", and then click "OK"

   

3. finally, click "OK"< br />

1. Select the cell to add

2, right-click / set cell format

3, number / classification / Accounting specific

4, confirm

First, we open excel on our computer, and then we input a number in it

Press and hold the "Ctrl" key, and then press "1", as shown in the figure