| 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. |
| 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 | |||
Threaded Mode
