Int digital currency

1.

To convert a number to a currency number is to set the value cell format to currency format. The following steps are as follows:

1. select the cell to be set, right-click to select the cell format

2. to open the cell Format dialog box, click the number tab (the general default number tab is activated)

3. 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:

2.

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

3. 1. Select the column to be operated, right-click set cell format
2, toolbar: number --- value --- OK

4. Hello
hold down the shift key and then press 4 keys
it's OK
there's nothing in word
it only represents personal opinions, don't spray if you don't like it, thank you.

5. int i = 60000;< br />string d=i.ToString(" c");

6. =SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(TEXT(INT(G5),"[ dbnum2]G/[UNK][UNK]州元quot;""" IF(MOD(G5,1),"& ",& " 整 ";;" ";)" TEXT(--RIGHT(INT(G5*10)),"[ dbnum2][> 0]#[UNK];[= 0]")& TEXT(--RIGHT(INT(G5*100)),"[ dbnum2][> 0]#[UNK];[= 0]整 quot;),& " 元0",& " 元零 quot;), 0,)," 整整 " 整")

7.

Use the corresponding function to convert the numerical RMB into capital in Excel. Please refer to the following steps for specific operation. The demo software version is Excel2007

First, open an excel file on the computer and enter the editing area, as shown in the figure

8. SUBSTITUTE(IF(-RMB(A1),IF(A1> 0," "" TEXT(INT(ABS(A1)+0.5%),"[ dbnum2]G/26684;- 20803;& quot; TEXT(RIGHT(RMB(A1,2),2),"[ dbnum2]035282;020998;; "),& quot; " IF(A1^2< 1," (million) br />
=SUBSTITUTE(IF(RMB(A1,2),TEXT(A1,"; "" TEXT(INT(ABS(A1)+0.5%),"[ dbnum2]G/26684;- 20803;& quot; TEXT(RIGHT(RMB(A1,2),2),"[ dbnum2]0d35282;020998;& quot;),& quot; " IF(A1^2< 1," " quot; " IF(AND(MOD(ABS(A1%),1000)< 100,MOD(ABS(A1%),1000)>= 10)," "" quot; """ quot; "" quot; quot;)

9. 函数解决这个很吃力，效率超低，可以考虑vba

曾经收藏了一段别人写的代码，7行，很精炼，分享学习一下
Function ldy888(M)
y = Int(Round(100 * Abs(M)) / 100)
j = Round(100 * Abs(M) + 0.00001) - y * 100
f = (j / 10 - Int(j / 10)) * 10
A = IIf(y < 1, "", Application.Text(y, "[DBNum2]") & "元")
b = IIf(j > 9.5, Application.Text(Int(j / 10), "[DBNum2]") & "角", IIf(y < 1, "", IIf(f > 1, "零", "")))
c = IIf(f < 1, "整", Application.Text(Round(f, 0), "[DBNum2]") & "分")
ldy888 = IIf(Abs(M) < 0.005, "", IIf(M < 0, "负" & A & b & c, A & b & c))
End Function

10. You have access to the access to the 3333333333333333333333333 /> datetime adDate
decimal adNumeric
float adDouble
int adInteger
money adCurrency
varBinary adVarBinary
varChar adVarChar