How to change the number in the table to currency format

1.

To convert a number to a currency number is to set the value cell format to currency format. The following steps are as follows:

1. select the cell to be set, right-click to select the cell format

2. to open the cell Format dialog box, click the number tab (the general default number tab is activated)

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

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

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

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

5.

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

6. Select the number range you want to change
right click to set the cell format, as shown in the figure below

select "number" -- "numerical value", and set it as you want

7. If the original ￥ is entered manually, excel will recognize it as text, so it cannot be directly converted to currency format
you can delete ￥ in batches by using the search and replace function, and then set it to currency format.

8. This is just a matter of setting the cell format.
1. Select the box where the value is said to be in,
2. Right click to find the setting cell format bar,
3. Click to enter, and then click the value or general in the option box,
4. OK to restore the value.

9.

The steps of setting currency style in Excel are as follows:

prepare materials: Excel software, computer

1. Open the Excel software and open the excel table to be edited, as shown in the figure:

10. Right click the table column to be displayed, set cell format, click currency format, and select currency symbol to confirm.