MBA that is about to hit the desk. As part of our training, we are doing sample projects for our team. One of the exercises is a comps output. Right now my formatting is as follows:
10.4x
9.8
My decimals aren't aligned. I know the decimals need to be aligned, but I can't figure out the custom formatting code to align it (our bank doesn't add the separate column for the x). Any help would be greatly appreciated!
| +433 | Is UBS really that bad? | 77 | 4h |
| +265 | Investment Banking is Divine | 40 | 2d |
| +219 | Another $115bn Mega deal for these banks. Congrats! | 46 | 10h |
| +216 | US 2027 SA IB worried about background check | 53 | 2d |
| +64 | Useless associates | 14 | 37m |
| +51 | Differences in Restructuring Teams? | 24 | 6h |
| +44 | FIG Pigeonholes you - is it true? | 14 | 50m |
| +40 | Is Houston SA 28 recruiting already over? | 34 | 1d |
| +38 | Roku-Fox Deal - UBS Misses Out on yet another deals after years chasing this deal | 8 | 2h |
| +36 | How do you manage nerves in IB technical interviews? | 8 | 13h |
Career Resources
Get instant access to lessons taught by experienced private equity pros and bulge bracket investment bankers including financial statement modeling, DCF, M&A, LBO, Comps and Excel Modeling.
Custom formatting, type -> “0.0x”
It seems like you would need to custom format the non x digits with 0.0_x. This adds a space to the number from the right side that equals the width of your multiple x. Also make sure your multiple format is 0.0x to match.
Sheesh man good luck with the rest of the year lmfao
Optio eveniet similique non architecto atque. Aut ea molestias aut sequi quia ipsam optio. Harum nam quis et autem quo odit quod totam. Suscipit vel delectus est excepturi. Dolor molestias tempore ut est quaerat.
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...