Currency number in document

1. If the data is in column a, you can enter the formula in B1:
= replace (A1, match (, 0 / mid (A1, row ($1): $99), 1),,, & quot; ￥")
press Ctrl + Shift + enter to end the formula, and then drop it down

3. Word pure blank file is not good, to be able to operate under the spreadsheet to display currency figures, otherwise you have to type a few decimal places. You can insert a spreadsheet in word (it's not good to insert a spreadsheet either) in the shortcut toolbar insert a spreadsheet enter the number you want select the cell you want to change right click Set cell format number currency change the number of decimal places you want to keep. Or directly use Excel (electronic form) to operate the same as above, right-click the cell to be transformed, and click Set cell format - number - currency - OK. Now the next version of WPS 2010, the function is also very good yo. Give the owner a WPS download link: http://xiazai.zol.com.cn/detail/9/88682.shtml If you have time to be familiar with the WPS operation, it will bring you a lot of convenience.

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.

The steps are as follows:

1. After opening the word document, click "more" in the symbol under the "insert" option

6.

Here is an operation flow of word number to currency format:

required materials: this method is only applicable to the numbers in the table

1. As shown in the figure below, the numbers are listed on the left. Click the first cell on the top right to enter the "layout" menu

7. There are many methods, such as data / column method, and (A1 is the text format with = -- A1)

8. Word does not support automatic generation and can only use other plug-ins< The steps are as follows:
1. After opening the word document, click "more" in the symbol under the "insert" option
2. In the insert special symbol dialog box, select the unit symbol option
3. Enter a number after the symbol.