Converting numbers into money
Publish: 2021-04-16 06:31:40
1. Select all the tables, and then Ctrl + Shift + ~ should be OK. The last symbol is the wave sign. Try it
2.
To convert a number to a currency number is to set the value cell format to currency format. The following steps are as follows:
-
select the cell to be set, right-click to select the cell format
-
to open the cell Format dialog box, click the number tab (the general default number tab is activated)
-
to select the currency symbol and decimal point according to your own needs, Then determine the specific recording operation of
< / OL >
as shown in the following figure:
3. 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?
4.
-
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
5. 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
6. 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.
7.
The operation method of changing RMB into US dollar in excel is as follows:
1. Select the cell range to be changed in
Second, right-click the cell range and click "set cell format" in the drop-down menu (or use the shortcut key Ctrl + 1); The format cell dialog box opens Third, select the number button in the set cell Format dialog box; At this time, the drop-down box of "number" appears (4) select "currency" in the drop-down box where "number" appears In the currency dialog box, change the RMB symbol to the US dollar symbol and click save. As shown in the figure below:
8. Bitcomputing power is a new business jointly established by 58coin exchange and miner manufacturers, mine pools and mine owners. Users can enjoy stable mining service by paying miner fees, electricity fees and management fees. Users can view it at any time in the background. The current business includes miner sales and custody, miner leasing and standard cloud computing power.
9. Tengjia enamel steel water tank is to use HSC series enamel as base glaze and surface glaze δ 2- δ 5. A new type of water tank is assembled by firing plates on enamel.
Tengjia stainless steel water tank is commonly used as stainless steel fire water tank, and the square combined water tank is made of SUS304 and stainless steel plate, which is formed by stamping.
Tengjia stainless steel water tank is commonly used as stainless steel fire water tank, and the square combined water tank is made of SUS304 and stainless steel plate, which is formed by stamping.
10. int i = 60000;< br />string d=i.ToString(" c");
Hot content