How to display currency symbol by Excel

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

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

bus line: No.3 → No.15, the whole journey is about 10.3km

1. Walk about 90m from Tonghua highway passenger station (old station) to passenger station

2. Take No.3 bus, pass 3 stations, and then reach Petrochemical station (or take No.39 bus)

3. Walk about 150m to Yamaha motorcycle monopoly station

4. Take No.15 bus, pass 11 stations, and reach gas station (G201)

5 Walk about 320 meters to the driver examination center of traffic police detachment of Tonghua Public Security Bureau

How to input currency symbol in Excel cell:

1. input currency symbol first and then number directly in cell

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

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 />

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

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

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