How to remove currency symbols and leave 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. If the currency symbol is displayed by setting the cell format, reset the format to remove it

if all are manually entered, you can search and replace with blank.

3.

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

4. The Angolo crater,

230 Burning Plain of real silver mine, sintland, Dongquan Valley, East plague, Angolo crater, barren land

230 scorching Canyon of black iron mine, burning plain, Blackstone abyss

250 burning plain of silver mine, Isala, Angolo crater Winter spring valley, East plague land, West plague land, hilisus, curse land, feywood forest

275 fuser silver mine east plague land, burning plain, West plague land, hilisus, winter spring valley, Isala, Angolo crater

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

6. Select all currency data,
Ctrl + H to call out the find and Replace dialog box
enter the currency symbol here
don't worry about it here. If it's empty, just click replace all
to delete the currency symbol

7.

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:

8. I know it's easy to have a separator, but what if there's no symbol? Take the number 879 as an example, assign 879 to... 1. Use the formula = left and = right

9.

The method to remove the percentage symbol of Excel is as follows (take excel 2019 version of windows 10 system as an example):

1. Open excel, and then select the cell to remove the percentage