The number format is currency type

1.

The reason for this phenomenon is that there is a problem in the setting. The specific solutions are as follows:

1. First, create a new excel document

2. After opening the file form, select the cell that needs to set currency, there is a format option in the upper right corner of the form, which can be set as currency. If you don't understand, please leave a message and ask. Thank you!

3. 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

4. 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?

6. 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

7. 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

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. Let's take a look at the differences between these formats, as shown in the following table:

Settings
description
examples

regular numbers (default values) display the input numbers as they are. 3456.789
thousand separator is used for currency; For negative number, decimal, currency symbol and decimal point position, follow the settings in Windows control panel. ￥ 3457
the euro uses the euro symbol (#8364;), The currency symbol specified in Windows regional settings is not considered&# 8364; 3456.79
at least one digit will be displayed. For negative numbers, decimals, currency symbols and decimal places, follow the settings in the windows "control panel". 3456.79
the standard uses thousands separator; For negative numbers, decimal symbols, and decimal point positions, follow the settings specified in the windows locale. 3456.79
percent multiplied by 100 plus percent sign (%); For negative number, decimal, currency symbol and decimal point position, follow the settings in Windows control panel. 123.00%
the standard scientific counting method was used. 3.46E+03