Money into numbers
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 formatThe 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:
-
the cursor is in front of the number and the point is inserted
-
select the currency symbol, such as & #;, Then click the insert button
-
just add. 00 after the number
-
select the number range to be changed
-
right click to set the cell format, as shown in the figure below
-
-
select "number" -- "numerical value", and set it as you want
Here is an operation flow of word number to currency format:
required materials: this method is only applicable to the numbers in the table
1. As shown in the figure below, the numbers are listed on the left. Click the first cell on the top right to enter the "layout" menu
http://eve.gtgame.com.cn/skill/skill.htm
take a look at the introction