How to remove the currency symbol in front of the number

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: 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

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.

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

9. Break this column of data into
data -- & gt; Column -- & gt; Separator symbol -- & gt; Text identifier;

10. On March 1, 1955, the people's Bank of China issued the second set of RMB, which officially determined the symbol of RMB. Because the unit of RMB is "Yuan", and the Chinese spelling of "Yuan" is "Yuan", the symbol of RMB adopts the first letter "Y" in the Chinese spelling of "Yuan". In order to distinguish between "Y" and Arabic numerals, we add two horizontal lines to "Y" to make "￥", and the pronunciation is still "Yuan". From then on, people began to use the symbol "￥" to express RMB, and use it as the head symbol when writing digital amount, such as "RMB 100" & "RMB 165"; 100 "or" RMB & # 165; 100”．