How to batch convert currency format to digital format
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:
enter the formula:
= -- A1
then the cell where the formula is located, paste the value to the place you want, and set the pasted cell to currency format.
-
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
there is no way to use the word "," ". In the numerical value. You can also convert it in Excel and paste it into the word document. If there are few cases, you can type it with symbols
it is relatively simple to implement all of them in word, and macro is needed. I don't know macro, so I can't help you
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
you can delete ￥ in batches by using the search and replace function, and then set it to currency format.
Use the text function
text function to convert a numeric value to text in a specified number format
syntax: = text (numerical value, format)
example: data in column d