How to delete currency symbol before number in table
Required raw materials: 2016 excel
method of adding and deleting currency symbol in Excel:
-
select the content of currency symbol to be added in the excel document
-
right click to select cell format, and select currency in the number (no need to select none)
< / OL >
select these cells → format → cells → numbers → general (or numerical value, and specify decimal places) → OK
if you don't set the currency format, ￥ is entered manually, you can use the method above.
if all are manually entered, you can search and replace with blank.
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
The fastest bus route from zhuanyang avenue to Wuhan Central Hospital is Metro Line 3: Rail Transit Line 3 → No.318, the whole journey is about 20.7 km
1. Take rail transit line 3 from zhuanyang Avenue, after 13 stops, to Fanhu station
2, walk about 1.0 km, to Xinhua Road Wanda station
3, take No.318, after 4 stops, After arriving at Houhu District Station of gusaoshu Road Central Hospital (you can also take bus No.812 and 294)
4, walk about 210 meters to Wuhan Central Hospital
< P > bus line: Rail Transit Line 3 → Rail Transit Line 2, the whole journey is about 22.4 km
1, take rail transit line 3 from zhuanyang Avenue, after 13 stops, to Fanhu station
2 Walk about 280 meters, transfer to rail transit line 2
3, take Rail Transit Line 2, pass 2 stops, reach Changgang Road Station
4, walk about 2.2 kilometers to Wuhan Central Hospital
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
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 Station3. 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
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.
1. Open the excel file where you want to delete the currency symbol. Then select the cells you want to process
