How to Format numbers from percentage points to basis points
 

Excel 2007; I need to know how to format a range of cells that contain
numbers that are percentages to display as basis points. An example would be
a cell that I have where the value is .035 and is displayed as 3.5% in this
example the result I want displayed would be 350. ( I suppose the
formatting technique I'm looking for is the opposite of moving from millions
to thousands using the comma in custom formatting area) Thanks for your help.

Answer: How to Format numbers from percentage points to basis points
 

Here's how you can format a range of cells that contain percentages to display as basis points:

1. Select the range of cells that you want to format.
2. Right-click on the selection and choose "Format Cells" from the context menu.
3. In the "Format Cells" dialog box, select the "Custom" category.
4. In the "Type" field, enter the following format code:
   Code:

   ---

   0.00%

   ---

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

1. Insert a new column next to the column with the percentages.
2. In the first cell of the new column, enter the following formula:
   Code:

   ---

   =A1*10000

   ---

   (Assuming that the percentage is in cell A1)
3. Press Enter to apply the formula to the cell.
4. 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.

How to Format numbers from percentage points to basis points
 

No formatting will change .035 to 350. You would have to physically change
the values by multiplying by 10000.

"Robaroo" wrote in message
...
Excel 2007; I need to know how to format a range of cells that contain
numbers that are percentages to display as basis points. An example would
be
a cell that I have where the value is .035 and is displayed as 3.5% in
this
example the result I want displayed would be 350. ( I suppose the
formatting technique I'm looking for is the opposite of moving from
millions
to thousands using the comma in custom formatting area) Thanks for your
help.