Remove the currency symbol before the number in the table

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: Rail Transit Line 3 → rail transit line 6, the whole journey is about 14.1km

1. Take rail transit line 3 from Wangjiawan to Hongkong Road station after 7 stops

2. Take rail transit line 6 after 3 stops to Shiqiao station

3. Walk about 460m to Wuhan Central Hospital

4.

bus line: no.216 → No.604, the whole journey is about 16.9km

1. Walk about 860 meters from Wujiashan to hehuayuan station of Wuzhong Street

2. Take no.216, pass 18 stops, reach huayuanxincun station of Changqing North Road

3. Walk about 90 meters, reach huayuanxincun station of Changqing North Road

4. Take No.604, pass 7 stops, reach Xinhua Jiayuan station of Hongqiqu road

5 Walk about 220 meters to the North Hospital of Wuhan Central Hospital

5.

bus line: Rail Transit Line 1 → No.211, the whole journey is about 7.9km

1. Take Rail Transit Line 1 at congtou road street, pass 1 stop, and then reach Erqi Road Station

< P > 2. Walk about 330m to Erqi road and Erqi Heng Road Station

3. Take No.211, pass 9 stops, and then reach Xinhua home station on Hongqiqu road

4. Walk about 160m, Arrive at the North Hospital of Wuhan Central Hospital

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

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

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

9.

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:

10.

Preparation tool: computer, Office2010

1. Open the form to be modified, and use the left mouse button in the main page of the form to select the cell to be modified