Word table number conversion currency capitalization

1. Right click "user defined cell format" = =, special = =, Chinese capitalization
if you are not satisfied, try this:
= numberstring (1234567890,1)
parameter 1 can be modified, 123456.. is a hypothetical number, which can be changed to cell name
if not, try this:
= subordinate (text (fixed (A1)), & quote[& gt; 0][dbnum2];[& lt; 0] negative [dbnum2]& quot;)& TEXT(RIGHT(FIXED(A1),2)," Yuan [dbnum2] 0 Jiao 0 fen& quot;& IF(ABS(A1)> 1%," Yuan integer & quot;,)& quot; Zero angle;, IF(ABS(A1)< 1,," Zero & quot;)& quot; Zero & quot& quot; Integer (& quot;)
where A1 is the cell of hypothetical data.

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?

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

4.

Tools: word software

1. First, use Excel to open the prepared worksheet, open the cell of setting currency format, and select the "number" option in the start tab< br />

5.

Materials / tools: word2016

1. Open the relevant word document, such as converting the amount number 15263 to capital

6. =
SUBSTITUTE(IF(A1>- 0.5%," 12367""& TEXT(INT(FIXED(ABS(A1)), "[ dbnum2]G/36890;-29992;-26684;-24335;-20803;&& quot;& TEXT(RIGHT(FIXED(A1),2),"[ dbnum2]035282;/020998;& quot;& IF(ABS(A1)> 1%, " .25972;quot;] quot; (38646;)35282", IF(ABS(A1)< 1," 38646,"] quot; .38646;. quot; 25972;quot;< br />26356;.

7. Directly use the replacement function of word. A total of 10 numbers, one by one to replace it. Or use the following methods:
1. Select the lowercase number to be converted, and then click Insert, and then click symbol, and then click No.
2. In the pop-up numbering dialog box, select the entry of uppercase number
3. When you go back to the document, you will find that the lowercase number has become uppercase number
of course, There are also some input methods that support the conversion of number case. For example, Sogou input method and so on.

8. It's so troublesome to tell you a formula:

= if ((int (G16 * 10) - int (G16) * 10) = 0, text (int (G16), & quot[ Dbnum2] g / general format & quot;)&& quot; Yuan & quot& IF((INT(G16*100)-INT((G16)*10)*10)=0," Integer & quot& quot; Zero & quot& TEXT(INT(G16*100)-INT(G16*10)*10,"[ Dbnum2] g / general format & quot;)&& quot; Points (& quot;), TEXT(INT(G16),"[ Dbnum2] g / general format & quot;)&& quot; Yuan & quot& IF((INT(G16*100)-INT((G16)*10)*10)=0,TEXT((INT(G16*10)-INT(G16)*10),"[ Dbnum2] g / general format & quot;)&& quot; Jiao Zheng & quot;, TEXT((INT(G16*10)-INT(G16)*10),"[ Dbnum2] g / general format & quot;)&& quot; Angle & quot& TEXT(INT(G16*100)-INT(G16*10)*10,"[ Dbnum2] g / general format & quot;)&& quot; Score (& quot;))

you this formula into excel, and then enter the number you want (Arabic numerals) in cell G16, and the amount you want in words will come out automatically. The formula is a little long, but very practical, I hope it will help you
of course, you can change the cell G16 in the formula to the cell you want.

9. Copy to word, right click to select Paste - text, try, it should be OK