Number format for basis points

[Charles]

Hello

I am certainly not the first to ask but I didn't find an answer yet.
Is there anyway to create a custom number format that allows to
display basis points in Excel?

For instance if I have a cell with the formula "=2.5%%", I would like
to see "2.5bps" appearing.

"0.0%%" allows to get "2.5%%" appearing. Any trick to get beyond that
step?

thanks in advance
Charles

 

[Bob Phillips]

Use a custom number format of 0.0"bps" and just enter 2.5

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)

 

[Nick]

Use a custom number format of 0.0"bps" and just enter 2.5

I think he is looking for something similar to % but that multiplies the
number by 10,000 instead of 100.

I've had to do it in apps. I can't remember seeing it done in excel.

 

[Charles]

I've had to do it in apps. I can't remember seeing it done in excel.

I guess that answers my question. Thanks!

Charles