Digital to English currency
http://support.microsoft.com/kb/213360
however, the results are rarely different from your requirements
= spellnumber (200)
display
two hundred dollars and no centers
it's very simple. It's the key to change the input method. You can hold down the key for a few seconds and change to digital input method
To use the "user-defined function" of converting numbers to English currency capitalization, the specific use method is as follows:
required materials: Excel, user-defined function of converting numbers to English currency capitalization (can be copied and pasted through the network)
First, open excel file, press Alt + F11 to open VBA window, insert a "mole"
Step 1: check the exchange rate first, assuming that it is 6.2 now, enter = A1 (original data storage point) / 6.2 in the new cell
Step 2: right click - set cell format - currency - select the symbol of U.S. dollar, which is generally the second one. The following is the operation step diagram "
of RMB500 as an example
you can choose the function name by yourself. After customization, it is as simple as using sum function. But VBA code is more complex.
the questioner's question 2009-08-19 10:30
the definition is generally on that page
the definition is generally not on that page. That's what primary programs do. As a good programmer, he will put a series of functions into a file to be included. Only in this way can we call each other conveniently. You can see from the "factory mode". If you do the same page, it is not necessary to do so many parameters.
B1 B1/p>
=SUBSTITUTE(IF(-RMB(A1,2),TEXT(A1,"; "" amp; TEXT(INT(ABS(A1)+0.5%),"[ dbnum2]G/26684;- 22278;& quot; amp; TEXT(RIGHT(RMB(A1,2),2),"[ dbnum2]035282;020998;; "),& quot; " IF(A1^2< 1," " quot; "" quot; ")