How to Format numbers from percentage points to basis points

R

Robaroo

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.
 
B

Bob Umlas

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Custom number format for basis points 0
Number format question 2
Custom 0\.00 Format with Comma 4
how to change percentage symbol (Excel XP) 1
Custom cell format for percentage 3
Number format for basis points 3
numbers in excel it automatically adds two decimal points in the . 1
Format Reporting Numbers to Thousands 4

Top