Apologies if there's something I'm completely missing, but is it possible to format a percent so that it shows up in bp format?
For example, could I type in 2.5% and have it show up as 250 bps?
Trending Content - Investment Banking Forum
| +209 | Return Rates For Interns Are Falling? | 85 | 1h |
| +128 | UBS Americas IB: The Kids’ Table of Wall Street | 16 | 1d |
| +104 | I am a drunk MD AMA | 39 | 34m |
| +80 | KISSED MY VP… HELP!!! | 14 | 16h |
| +63 | VP Lifestyle at Top BB Coverage Groups | 40 | 19h |
| +57 | An Outsider’s View of RX Banking Out of College | 6 | 3d |
| +49 | SharePoint makes IB hours HELL | 15 | 3d |
| +49 | UBS Offer Day | 18 | 17h |
| +44 | momentum of Rx groups | 16 | 23h |
| +34 | WF Return offers | 20 | 19m |
Career Resources
Use a custom number format.
Right, but what would I type in? How do I make 2% into 200 bps? I know I can change the format to ### "bps", type in "200" and it would show up as "200 bps." However, I need to have percentages do that.
Hmm, I don't think it's possible, actually.
It is possible with custom number formats. See the below link, and scroll down to the part about thousands separators. The relevant operator is the comma.
http://office.microsoft.com/en-us/excel/HP012165031033.aspx
Oh, off the top of my head, I'm not sure - I can't really think of a custom number format that would display a percent a hundreds number.
I would probably just insert a column, and use a quick multiplier, followed by a custom format - quick and easy.
Thanks guys
How about displaying numbers in millions. e.g.: 222,333,333.34 --> 222mm
Sit eveniet dolore ab quod. Laboriosam iusto similique cum aperiam provident sapiente. Rerum fugit alias atque reprehenderit magnam similique iure pariatur.
See All Comments - 100% Free
WSO depends on everyone being able to pitch in when they know something. Unlock with your email and get bonus: 6 financial modeling lessons free ($199 value)
or Unlock with your social account...