The numbers are in the currency class of the cell format
The number in excel is changed into currency "#" format mostly e to the use of other formats, which can be changed back to numerical value or conventional. The specific steps are as follows:
required materials: Excel
First, open the excel file and select the number cell in currency format
The reason for this phenomenon is that there is a problem in the setting. The specific solutions are as follows:
1. First, create a new excel document
To convert a number to a currency number is to set the value cell format to currency format. The following steps are as follows:
-
select the cell to be set, right-click to select the cell format
-
to open the cell Format dialog box, click the number tab (the general default number tab is activated)
-
to select the currency symbol and decimal point according to your own needs, Then determine the specific recording operation of
< / OL >
as shown in the following figure:
1. If the number is pasted, please select the value "123" in
"paste special"
2. If the number is manually entered, please right-click the cell containing the number, Set the cell format, select "general"
or select the cell containing numbers, and then click Ctrl +! Shortcut key, you can quickly open the cell Format dialog box, select "general" or other data types you need.
1. First, you need to open the Excel software in the computer, open the data, select the cell, and right-click the cell
Method:
1. Open excel table and select the cell to be set as currency format
1. Right click on the separate cell to be set,
2. Select "set cell format" in the pop-up menu
3. Select "number" in the dialog box
4. Input after the number and decimal: 2, Click the mouse before using the thousand separator to change to the checked status
5. Click OK
after setting in this way, the problems encountered can be solved.
bus line: Metro Line 7 → Metro Line 3, the whole journey is about 22.2km
1. Take Metro Line 7 from Guangzhou south station, pass 4 stations, reach Hanxi Changlong station
2, walk about 170m, transfer to Metro Line 3
3, take Metro Line 3, pass 7 stations, reach Zhujiang New Town Station
4, walk about 720m, reach Guangzhou international financial center