Convert Percent to Basis Points Format

[atgordon]

Does anyone know if there is a customer format I can use to change the percent value of a cell to basis points? I tried creating my own, but was having difficulty. For example, if the cell value in A1 is 2%, I would like to have it say 200 basis points instead.

Thanks.

 

[Richard Schollar]

I do not believe there is (would love to be proved wrong, however) - the closest I could get to it was to use a format like:

0%%

If you use this and input 0.02 then it displays as:

200%%

which isn't really ideal.

 

[zee301]

atgordon,

Did you try to change your formula to multiply by 10000 and then format as a number? That's our workaround!

 

[Giordano Bruno]

This site will give you what you want.

Custom Number Formats (Multiply & Divide by any Power of 10) | Chandoo.org - Learn Microsoft Excel Online

 

[arjunambiar]

multiply the % by 10000 and right click, format cell, under Numbers Tab click on custom and add the code below code under Type:

0 "bps";(0 "bps");-

 

[Michael M]

@arjunambiar
I think you're a bit late on this one.....the thread was started 10 years ago !!!

 

[SunshineKelly]

multiply the % by 10000 and right click, format cell, under Numbers Tab click on custom and add the code below code under Type:

0 "bps";(0 "bps");-

Arjunambiar, This worked great! Thank you for the custom format info

 

[cmsnja]

This worked perfectly!! Thank you!!