How to convert a numeric amount to a kanji amount

strm:=''; i:=s2[1]+s2[2]+s2[3]+s2[4]+s2[5]; strq:

Zero One Two Three Wu Lu Qi picked up'; strx:='Pick up thousands of dollars and angles'; for k:=1 to 8 do begin j:

i mod 10 ;// textout(intz[9-k],lh,copy(strq,j*2+1,2));if i>0 then strm:=copy(strq,j*2+1,2)+copy(strx,(8-k)*2+1,2)+strm; i:=i div 10; textout(sp[7]-40,lh,formatfloat('####',(s2[1]+s2[2]+s2[3]+s2[4]+s2[5])/;textout(sp[3],lh,strm); end; end;Use a string,Define a good billion,Hundreds of thousands of dollars and angles,And then the numbers are processed as strings,Of course, it is best to deal with the integer first,Start with a large single digit,Apply The following schematic**The above is a piece of source code in the Fadu example I did View the original post".

Write a function (s=''1. If ** is not a string, convert it into a string first; string m[5]= string n[2]= string hs,hnum;2. Processed according to the string operation: len:=length(s); dot:

ansipos('.',s);decimal place begin num[i]:=copy(s,i,1); Respectively the number hs:

'; case num[i] of '1':hnum:='One'; '2':

if (dot>i) hs:=hs+hnum+m[dot-i] else beginfor i:=1 to len do this paragraph itself; end; end;View the original post

How do you convert the numeric amount to the Chinese character amount, or is there a special article over there? View the original post

Yes, for example, ' to '佰贰拾叁整' View Original Post

In Excel, you can convert Chinese characters to specified numbers, as required by the question, you can enter the formula "=vlookup(a1,,2,0)" in column C.

Taking Excel2013 as an example, the steps are as follows:

1. Run Excel2013 and enter these specified Chinese characters.

2. Enter the formula "=VLOOKUP(A1,,2,0)" in cell C1.

3. Enter the formula and press enter, you can see that the conversion is completed and meets the requirements.

4. Tap the cross in the lower right corner of cell C1 and drag down to fill it.

5. Complete the whole conversion and meet the requirements.

1. Open Excel** on the computer.

2. The premise of the quick drop-down is that the previous column must have content, then enter the number in column B, and then double-click the filling handle in the lower right corner.

3. After double-clicking the fill handle, you can quickly fill thousands of rows, click the icon in the lower right corner.

4. You can choose to fill the sequence.

5. You can turn it into a number.

In Excel, you can convert Chinese characters to specified numbers, as required by the question, you can enter the formula "=vlookup(a1,,2,0)" in column C.

Taking Excel2013 as an example, the steps are as follows:

1. Run Excel2013 and enter these specified Chinese characters.

2. Enter the formula "=VLOOKUP(A1,,2,0)" in cell C1.

3. Enter the formula and press enter, you can see that the conversion is completed and meets the requirements.

4. Tap the cross in the lower right corner of cell C1 and drag down to fill it.

5. Complete the whole conversion and meet the requirements.

The following is the method of converting numbers to amounts in Excel and Word for your reference, I hope it can help you.

The first is how excel can quickly convert values into amounts.

First of all, open the data that needs to be done in the computer excel**.

Enter the formula =rmb() in the cell, and rbm is RMB.

Then enter the number cell in parentheses for the amount you want to convert.

After entering, press the enter key, and it will become the amount.

After entering, press the enter key, and it will become the amount.

Word method.

Insert a number, enter Arabic numerals in the "Number" field, and select the uppercase amount type in the "Number Type".

If there are a large number of values, you can use macros to automatically complete the conversion in batches.

It can be converted in Excel.

1. Open Excel, and then open the one you want to convert. As shown in the figure below:

2. After opening Excel**, enter the formula =text(A1,"[dbnum1]"Class"。As shown in the figure below:

3. After entering the formula, press enter to convert to Chinese characters. As shown in the figure below:

4. Select the cell with the formula, and drop down to copy the formula. As shown in the figure below:

Liyan mu can be realized.

Steps. 1. ** in a word as shown in the figure below.

Steps. Second, then we write a random number under the lowercase.

Steps. 3. Next, in the cell below the capitalization, press ctrl+f9 to insert the field.

Steps. Fourth, and then write c4 in the field *chinesenum2 Explanation: ** in word also has the same correspondence as excel, from left to right is the ABCD column, from top to bottom is 1234 rows, the cell where the number is filled in is the 4th column C, so it is C4.

Steps. 5. Then you select all of them, press f9, and it will become the amount capitalized in Chinese characters.

Steps. Sixth, in the future, you can change the number casually, and then press F9, and it will change from the rough rock forest.

<> Note: This method only works between 0-999999 numbers.