How to separate currency symbols from numbers
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
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:
The solution steps are as follows:
-
first select the cell where you want to insert currency symbol and number, then right-click and select set cell format in the pop-up box
-
select the number in setting cell format, and then select custom options
-
select 0.00 in the customization, then add the currency symbol in the input box, and click OK. The currency symbol will be added automatically after entering the number in the cell
after this setting, you do not need to input currency symbol any more, you can input number directly to display both currency and number.
if the former is a fixed serial number, it is equidistant; After that, the data are sorted by symbol.
the first character (i.e. number) is the first column, the second character (i.e. comma) is the second column, and the rest (i.e. letter) is the third column.