To remove the decimal point but keep the numbers after it, you can use the following steps:
- Select the cell(s) containing the price you want to format.
- Right-click on the selected cell(s) and choose "Format Cells" from the context menu.
- In the "Format Cells" dialog box, select the "Custom" category.
- In the "Type" field, enter the following format code:
- Click "OK" to close the dialog box.
This will format the cell(s) to display the price without the decimal point, but retaining the numbers after it. For example, $47.50 will be displayed as
4750 and 119.00 will be displayed as
11900.