The number category is set to currency
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
-
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
you can set it in Excel and it to word. The effect is the same
the operations in Excel are as follows:
select data & gt& gt;& gt; Right click & gt& gt;& gt; Set cell & gt& gt;& gt; Check the number column & gt& gt;& gt; Click "currency" and choose the one that meets the requirements
I hope it can help you
in Excel, there are cell options (Ctrl + 1) in the format form, click the tab, and currency and accounting specific currency input forms are available in the number part.
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
select the number of decimal places in the red circle
if not, then
format - row - row height - enter a large number to see