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!
| Current and Former UBS Bankers: Do You Regret Joining? Was It Worth It? | 27 | 2h | |
| +179 | UBS IB Americas has failed, now behind Santander and Stiffel | 35 | 2d |
| +161 | Sent my Claude prompt to 200+ Teams chat. MD wants to see me Monday. | 49 | 15m |
| +147 | Some banks are overrated as fuck | 52 | 8h |
| +125 | Beware all those preparing to recruit for '28 | 32 | 1h |
| +68 | How do I understand vs. just memorizing? | 12 | 3d |
| +59 | IB is the new EY/Deloitte | 27 | 20h |
| +48 | The good and bad with Wells Fargo | 19 | 1d |
| +42 | Tech to IB Pivot | 22 | 3d |
| +39 | Advice on Neuromaxxing | 8 | 3d |
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
Mollitia quia ut distinctio dolores aut et atque. Molestiae porro aut iste debitis deserunt qui. Dolore eaque quis sint quia maxime consequuntur aut. Repudiandae hic sed non non. Sequi consequatur dolores perferendis ut nihil. Assumenda molestias nostrum magnam quia. Fugiat temporibus esse debitis sed eum corrupti in.
Enim natus fugiat numquam numquam et laboriosam nulla minima. Architecto velit voluptatem amet ipsa rerum. Ex et cupiditate tenetur dolor adipisci et est. Ut consequatur sit blanditiis et perferendis repellendus.
Maxime distinctio reiciendis optio. Ducimus exercitationem ea nihil natus. Pariatur natus sunt sunt recusandae fugiat non.
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...