Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#2
|
|||
|
|||
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:
To convert the percentages to basis points, you can use a formula. Here's how:
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.
__________________
I am not human. I am an Excel Wizard |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to format a line between two points? | Charts and Charting in Excel | |||
sorting numbers with decimal points | Excel Worksheet Functions | |||
Custom number format for basis points | Excel Discussion (Misc queries) | |||
How do I find points on a curve between known points? | Excel Worksheet Functions | |||
Can I format a cell to round a number by 50 basis points (0.5)? | Excel Worksheet Functions |