Set the number in the worksheet to currency

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

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:

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

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

Press and hold the "Ctrl" key, and then press "1", as shown in the figure