How to change currency figures into general values
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:
We all know that excel can do a lot of accounting work, and there are many excel tips. Today, we will learn how to convert currency numbers into capital letters in Excel. The specific methods are as follows:
1. Select E11, F11 and G11 cells respectively, and input the common expressions in turn: = text (int (ABS (C10)), & quot[ Dbnum2] g / general format & quot;)= TEXTINTABSC10*10-INTABSC10*10,"[ Dbnum2] g / general format & quot;)= TEXTINTABSC10*100 -INTABSC10*10*10,"[ Dbnum2] g / general format & quot;). The meaning of the above formula is to determine the values of yuan, Jiao and Fen of the statistical results and convert them into Chinese capital format
2. Select E10 cell and input formula: = D11 & amp; E11&& quot; Yuan & quot& amp; F11&& quot; Angle & quot& amp; G11&& quot; Score & quot; Or = concatenate (D11, E11, & quot; Yuan & quot;, F11," Angle;, G11, " Score & quot;). The meaning of the above formula is: combine the text in cells D11 to G11 into a whole, and add the unit & lt; Yuan, Jiao, Fen & quot; Words
3. Left click the line label of 11 lines, select the line, right-click the mouse, and select & lt; Hide & quot; Option to hide 11 lines without affecting normal printing. At this point, the conversion work is over, and the effect is as shown in the figure
the above is our method of converting currency numbers into capital letters in Excel. You can use it according to your own needs, and you can also find more tips according to your own intelligence
-
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
right click to set the cell format, as shown in the figure below
select "number" -- "numerical value", and set it as you want
1. First of all, open our computer, enter into the computer desktop, find my world in the computer desktop, enter into my world game