Setting digital currency format in word
Publish: 2021-05-28 15:38:24
1. 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?
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?
2.
-
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
3. Hello, word does not have this conversion function. However,
you can set it in Excel and it to word. The effect is the same
the operations in Excel are as follows:
select data & gt& gt;& gt; Right click & gt& gt;& gt; Set cell & gt& gt;& gt; Check the number column & gt& gt;& gt; Click "currency" and choose the one that meets the requirements
I hope it can help you
you can set it in Excel and it to word. The effect is the same
the operations in Excel are as follows:
select data & gt& gt;& gt; Right click & gt& gt;& gt; Set cell & gt& gt;& gt; Check the number column & gt& gt;& gt; Click "currency" and choose the one that meets the requirements
I hope it can help you
4. If you don't have to fight with your hands. There is no such function in word, so you can only insert the ¥ character in word
there is no way to use the word "," ". In the numerical value. You can also convert it in Excel and paste it into the word document. If there are few cases, you can type it with symbols
it is relatively simple to implement all of them in word, and macro is needed. I don't know macro, so I can't help you
there is no way to use the word "," ". In the numerical value. You can also convert it in Excel and paste it into the word document. If there are few cases, you can type it with symbols
it is relatively simple to implement all of them in word, and macro is needed. I don't know macro, so I can't help you
5. 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.
6. 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.
7.
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 />
8.
The steps are as follows:
1. After opening the word document, click "more" in the symbol under the "insert" option
9. There is no ready-made automatic currency format conversion function in word. The only thing closest to your needs is that if there are formula cells (summation, average value, etc.) in the word table, you can set currency format for the data in this cell
for word2007, the entry is "table tool layout formula", and then specify the required currency format in "numbering format". You can evaluate, average, and format the current column or row< br />
______
Add:
suppose you have a table containing several data, if you want to add the summary value of the above data in the last row. Then you can do this:
1. Place the cursor in the last row where you need to add a summary
2. Select the command "table tools layout data formula" on the toolbar (at the far right of the toolbar of table layout)
3. In the pop-up "formula" window, select the "number format" as you need (according to the requirements of your topic, you can choose the form of "#, # #, 0.00" here)
4. After confirmation, you can see that a summary value is inserted into the current cell, and the format is the one you want
note that if you later modify the data in the table, you need to refresh the summary value - click on it, and then type F9.
for word2007, the entry is "table tool layout formula", and then specify the required currency format in "numbering format". You can evaluate, average, and format the current column or row< br />
______
Add:
suppose you have a table containing several data, if you want to add the summary value of the above data in the last row. Then you can do this:
1. Place the cursor in the last row where you need to add a summary
2. Select the command "table tools layout data formula" on the toolbar (at the far right of the toolbar of table layout)
3. In the pop-up "formula" window, select the "number format" as you need (according to the requirements of your topic, you can choose the form of "#, # #, 0.00" here)
4. After confirmation, you can see that a summary value is inserted into the current cell, and the format is the one you want
note that if you later modify the data in the table, you need to refresh the summary value - click on it, and then type F9.
10. Copy to excel, set cell format to currency, and then paste back to word.
Hot content