Arabic numerals adjusted to currency

1. Use Excel to right-click the shortcut menu in the cell where you want to enter numbers, select "set cell format", select Chinese capital numbers (there are two, the second is traditional) in "special" under the "number" option, and click "confirm"
Arabic numerals are international common numbers nowadays. It was first invented by Indians, then spread to Europe by Arabs, and then modernized by Europeans. Because of the spread of Arabs, it became the key node for the number to be used internationally, so people called it "Arabic numeral" (it can also be said that people mistakenly called it Arabic numeral)
Arabic numerals are composed of 10 counting symbols: 0, 1, 2, 3, 4, 5, 6, 7, 8 and 9. Take the bit value method, high in the left, low in the right, from left to right writing. With the help of some simple mathematical symbols (decimal point, minus sign, percent sign, etc.), this system can clearly represent all rational numbers. In order to represent the maximum or minimum number, people created the scientific notation on the basis of Arabic numerals
in Chinese, the amount in words should be filled in block letters or running script, such as one, two, three, four, five, six, seven, eight, nine, ten, ten, ten, ten, ten thousand, hundred million, yuan, Jiao, Fen, zero, whole (positive), not in one, two (two), three, four, five, six, seven, eight, nine, ten, Mao, another (or 0), and not in simplified words. If the amount of figures written in traditional Chinese characters, such as two, six, billion, million, yuan, should also be accepted

the following should also be noted in the correct writing of RMB in words:

1. If the amount in words in Chinese is up to "Yuan", the word "whole" (or "positive") should be written after "Yuan"; After "Jiao", the word "Zheng" (or "Zheng") may not be written; If the amount in words has "Fen", the word "whole" (or "positive") shall not be written after "Fen"

2. In Chinese, the words "RMB" should be indicated before the amount in words, and the amount in words should be filled in immediately after the words "RMB", and no blank space should be left. If the words "RMB" are not printed before the amount in words, the three words "RMB" shall be added, and the fixed words "thousand, hundred, hundred, ten thousand, thousand, hundred, ten thousand, yuan, Jiao, Fen" shall not be pre printed in the amount in words column of bills and settlement vouchers.

2. I understand that there is no such function in

word,

but you can use macros. I'm not good at macros. Please try to extract other people's macros; You can use the following macro. You need to specify the shortcut key
sub temp()

selection. Text = format (selection. Text, & quot; # #, # # 00") < br />
End Sub ' Do you want to name it by yourself?

4. Hello, word does not have this conversion function. However,
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

5. If you don't have to fight with your hands. There is no such function in word, so you can only insert the ￥ character in word

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

6. First the number to excel, then set the number format to currency format in Excel, and then and paste the table containing these numbers into word (remember to paste a single cell into word in 2003 version, otherwise word will crash), and then these numbers from the pasted table to the position where they should be.

7.

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

8. Select the area, click Format - cell - number - special in the menu bar, and change it to Chinese capital number.

9. 打开VB编辑器，新建一模块，输入以下代码：
Public Function RMBDX(M)
RMBDX = Replace(Application.Text(Round(M + 0.00000001, 2), "[DBnum2]"), ".", "元")
RMBDX = IIf(Left(Right(RMBDX, 3), 1) = "元", Left(RMBDX, Len(RMBDX) - 1) & "角" & Right(RMBDX, 1) & "分", IIf(Left(Right(RMBDX, 2), 1) = "元", RMBDX & "角整", IIf(RMBDX = "零", "", RMBDX & "元整")))
RMBDX = Replace(Replace(Replace(Replace(RMBDX, "零元零角", ""), "零元", ""), "零角", "零"), "-", "负")
End Function

假如你要转换的数值在A1单元格，在B1或其他单元格输入＝ RMBDX(A1)
这是自定义函数，office 2003里面应该有带的