How to make word number into currency format
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?
-
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
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
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
in Excel, there are cell options (Ctrl + 1) in the format form, click the tab, and currency and accounting specific currency input forms are available in the number part.
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 />
The founder of reborn is not. Reborn was founded by ripple labs, a San Francisco company
reborn coin is founded by ripple labs, a San Francisco company. Just like the special coin, reborn coin is also a kind of public database that can be shared. At the same time, it is also a global general ledger of revenue and expenditure
and sun Yuchen is the founder of BoChang Tron, the founder and CEO of mobile social application companion app, the founder and CEO of Ruibo, the founder of fortune free revolution road and the founder of BoChang Tron foundation. Therefore, the founder of reborn is not sun Yuchen, but ripple labs
extended information:
user a can convert any kind of currency or virtual currency into XRP, and then send it to user B in any other region. User B can convert the received funds into any currency he needs
there is another mode, user a will deposit the funds in the gateway trusted by user B and transfer them to user B through the gateway. Ruibo system also allows users to issue "private currency" in the system
If a certain user a has a good reputation, he / she can exchange his / her "private currency" with another one he / she trusts and is willing to accept into other currencies such as US dollars or bitcoin
user B can redeem the currency converted to user a as needed. This is actually a lending process. User a has the financing right to borrow from others
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.