Here's how you can format a range of cells that contain percentages to display as basis points:
- Select the range of cells that you want to format.
- Right-click on the selection 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 on the "OK" button to apply the format to the selected cells.
To convert the percentages to basis points, you can use a formula. Here's how:
- Insert a new column next to the column with the percentages.
- In the first cell of the new column, enter the following formula: (Assuming that the percentage is in cell A1)
- Press Enter to apply the formula to the cell.
- Copy the formula to the rest of the cells in the column by dragging the fill handle (the small square at the bottom-right corner of the cell) down to the last cell in the column.
This will multiply the percentages by 10,000 to convert them to basis points. The result will be displayed in the new column. You can then hide or delete the column with the percentages if you don't need it anymore.