Print out accounting currency number in word document
-
the cursor is in front of the number and the point is inserted
-
select the currency symbol, such as & #;, Then click the insert button
-
just add. 00 after the number
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
the way to input such data in excel is as follows:
select the cell area to be input, right-click the area, and select set cell format / number / currency in the pop-up shortcut menu. Select none as the currency style in the dialog box, and - 1234 as the negative number style, and then click OK.
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.
after setting in Excel, to word:
1. Setting in Excel: select the cell range to be input, right-click the range, and select "set cell style" -- "number" and "currency" in the pop-up shortcut menu to select "None" in the dialog box, The negative number style can be selected as "- 1234" and "affirmative"
2. After setting it in Excel, "" it, and then "Edit" -- "paste selectively" -- "no style text" in word
with the "replace all" button, the thousand separator of financial data in the whole document can be added, and the year number is not affected. The specific methods are as follows:
1. Use the CTRL + H shortcut key, or click the menu or button:
in the version below 2007, click the "Edit" menu in word, and click "replace" in the drop-down menu to open the "find and replace" dialog box
for 2007 and above, click Edit in the function area, and then click & quot; Replace & quot
2. For versions below 2007, click Advanced; 2007 and above, click the "more" button and check the "use wildcard" check box
3. Fill in: ([0-9]) ([0-9] {3}) ([!][ (0-9 years)], in "replacement", fill in: 92; 1,\ 2\ 3
note: search content: ([0-9]) ([0-9] {3}) ([!][ (0-9 years)] and replace with: &92; 1,\ 2\ 3 is fixed, in the input method for English half angle state input
4. Execute "replace all" and press the "replace all" button repeatedly until "replace 0" is prompted.
There is no way to automatically realize the special format of Digital Accounting in word, only by writing macro commands manually
the specific steps are as follows:
1. Open word 39;
2. Press Alt + F11 to open VBA editor and click Insert - & gt; Mole
Materials / tools: WORD2010
1. Open the WORD2010 document and type VBA editor