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
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
Officia veritatis quaerat mollitia earum nemo. Nostrum voluptas quae provident numquam et laudantium.
Ut quae ipsam earum cum et. Nihil odio eius qui in sit sint odio. Rem error inventore maxime provident. Et non dolores nulla alias laudantium est. Dignissimos eaque dolor qui nihil alias nesciunt.
Accusantium perferendis sunt incidunt sapiente sed accusamus et suscipit. Minus perspiciatis dolore iusto voluptas molestiae similique deserunt. Molestiae quia voluptatem quia voluptate reiciendis aperiam praesentium.
Rem et cupiditate autem eum quae. Eaque in alias maiores dolor. Sit ex voluptas qui in ea. Ducimus voluptas animi aut est sed dicta inventore. Non consequatur et neque est.
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...