Change the currency format in the text
Publish: 2021-05-10 07:07:20
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
= replace (A1, match (, 0 / mid (A1, row ($1): $99), 1),,, & quot; ￥")
press Ctrl + Shift + enter to end the formula, and then drop it down
2. Suppose the text is in A1,
enter the formula:
= -- A1
then the cell where the formula is located, paste the value to the place you want, and set the pasted cell to currency format.
enter the formula:
= -- A1
then the cell where the formula is located, paste the value to the place you want, and set the pasted cell to currency format.
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. 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
7. 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.
8.
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 />
9.
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
10. The common material of enamel water tank is hot-rolled pickling steel with yield strength of 245
Hot content