How to change table currency into figures
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:
= replace (A1, match (, 0 / mid (A1, row ($1): $99), 1),,, & quot; ¥")
press Ctrl + Shift + enter to end the formula, and then drop it down
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
1. First of all, open our computer, enter into the computer desktop, find my world in the computer desktop, enter into my world game
First, we open excel on our computer, and then we input a number in it
"OK" -- enter data, as shown in the figure:
1. Select the range of cells you want to set