Formula of numeral conversion component lattice with currency ma

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

3.

Take excel 2016 as an example, there are the following steps:

1. Open an excel worksheet, as shown in the figure below:

4.

bus line: No.3 → No.15, the whole journey is about 10.3km

1. Walk about 90m from Tonghua highway passenger station (old station) to passenger station

2. Take No.3 bus, pass 3 stations, and then reach Petrochemical station (or take No.39 bus)

3. Walk about 150m to Yamaha motorcycle monopoly station

4. Take No.15 bus, pass 11 stations, and reach gas station (G201)

5 Walk about 320 meters to the driver examination center of traffic police detachment of Tonghua Public Security Bureau

5. Go out to install, repair and debug equipment for customers.

6. Format & gt; Cell format & gt; Value & gt; Custom number format

7.

The operation method of adding currency symbol to cells in excel is as follows:

1. first, select cells (such as m54), right-click the cell range, and select "set cell format"

2. next, click "number" -- "currency", select the corresponding currency symbol, such as "￥", and then click "OK"

   

3. finally, click "OK"< br />

8. That's your code

9. Suppose C6 is your total amount in Arabic, and the following is in Chinese words
= if (int (C6) - C6 = 0, text (C6, & quot[ Dbnum2] [$- 804] g / general format & quot& quot; Yuan Zheng & quot& quot;& quot;), TEXT(INT(C6),"[ Dbnum2] [$- 804] g / general format & quot& quot; Yuan & quot& quot;& quot;)& TEXT(RIGHT(INT(C6*10),1),"[ Dbnum2] [$- 804] g / general format & quot& quot; Angle & quot& quot;& quot;)& TEXT(RIGHT(INT(C6*100),1),"[ Dbnum2] [$- 804] g / general format & quot& quot; Score & quot& quot;& quot;))

explanation: if (int (C6) - C6 = 0, one string, another string), if C6 is an integer (function int means rounding, subtracting the original number to 0 after rounding, it means integer), return one string, otherwise return another string
the function text (number, "format") changes the number to the specified format, and "[dbnum2] [$- 804] g / general format" is the Chinese uppercase format
the function right returns the last few digits of the string
meta angular division is also a part of the scheme& quot; Indicates a quotation mark within an existing quotation mark.

10. 20551;"25454;" A1"21017;" B136755;"br />=TEXT(INT(A1),"[ dbnum2]"& quot; " TEXT(--RIGHT(A1*100,2),"[ dbnum2]0d35282;020998;")& TEXT(A1," (Translated with Google Translate) "]