Method 1 sets the currency format in the table to numeric format:
1. Open the "Format Cells" dialog box and click "Customize" under the "Number" tab.
2. Click "Type" and move the cursor to the beginning of "#,##0.00".
3. Enter “￥”.
4. Then click OK.
The RMB symbol ("￥") will be added at the beginning of the number. "￥#,##0.00" is the format used in currency format. So currency is displayed in numeric format.
RMB symbols have been added to cells D4, D5, D6, and D9.
Method 2 sets the currency format in the table to numeric format:
Step 1: Open the workbook window and select the cells where you want to format currency numbers. Then right-click the selected cell and select the "Format Cells" command in the shortcut menu that opens, as shown in Figure 1.
Step 2. Open the Excel "Format Cells" dialog box and switch to the "Number" tab. Select the "Currency" option in the "Category" list, set the number of decimal places in the "Decimal Places" drop-down box on the right (the default is 2 digits), and select the type according to actual needs in the "Currency Symbol" drop-down list ( The currency symbol list contains 390 currency symbols from different countries and regions), and then select the representation type of negative numbers in the "Negative Numbers" list box. After the settings are completed, click the "OK" button, as shown in Figure 2.
The currency numbers with currency symbols added are shown in Figure 3.
Summary: The above is the entire content of "How to set the currency format in the table to numeric format_Two methods".
Editor’s recommendation:
How to enter data horizontally in cells
How to align text box to cell
How to copy the numerical value of a formula cell calculation result
评论列表