How to get rid of the currency of table figure money
if all are manually entered, you can search and replace with blank.
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
and then select these numbers and click the exclamation mark to convert the text to a numerical value.
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:
bus line: Rail Transit Line 4 → Rail Transit Line 2, the whole journey is about 13.0km
1. Walk about 210m from Wuchang station to Wuchang railway station
2. Take rail transit line 4, pass 2 stations, and reach Zhongnan Road Station
3. Take Rail Transit Line 2, pass 7 stations, and reach Zhongshan Park Station
4. Walk about 340m, Arrive at Wuhan International Convention and Exhibition Center
In Excel 2003, you can set the value in the cell as the default currency style by clicking the currency style button in the toolbar. In Excel 2007 / 2010, the way to set the default currency style is to select the start tab and select currency from the number format drop-down list in the number group. Sometimes, you need to change the default currency style to other styles, such as setting the currency symbol to "$" or "&8364;", This needs to be modified in the control panel. Take Windows XP as an example, the method is as follows:
1. Click start → settings → control panel, double-click regional and language options, select Regional Options tab, and click Custom. You can also select a language directly from the drop-down list to the left of custom, but this will affect the number, date, and time formats at the same time
3. Click OK twice
in this way, the currency style set later in excel through the toolbar button or "number format" in the "Ribbon" is the modified currency style
select the cell range to be changed, right-click and select & quot; from the right-click menu; Format Cells & quot;, In the pop-up & quot; Cell format & quot; In the dialog box & quot; Digital & quot; Tab & quot; Classification & quot; Select the format you want from the & quot; General & quot& quot; Numerical value & quot; Or & quot; Text & quot; Click OK when finished
Change the currency format of the cell to the normal or numerical format to remove the RMB symbol
1. Open excel 2016