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!
| +338 | Return Rates For Interns Are Falling? | 143 | 45m |
| +156 | Evercore > Goldman and I don’t think it’s particularly close anymore | 58 | 19m |
| +152 | Article: Why UBS's Asian M&A bankers are thriving and UBS's American M&A bankers are not | 17 | 10h |
| +124 | I am a drunk MD AMA | 40 | 1d |
| +86 | UBS Offer Day | 30 | 1d |
| +75 | Santander IB? | 10 | 3d |
| +68 | I hate Wells Fargo | 19 | 7h |
| +51 | No return offer - feeling like a failure is an understatement | 20 | 2h |
| +45 | How cooked am I as an incoming WF IB SA 2027? | 17 | 3h |
| +43 | WF Return offers | 28 | 2d |
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
Voluptate odio et nemo aut voluptate repellendus illum. Delectus natus laboriosam est quo aperiam est. Vel deserunt vero natus quia. Error ullam omnis non aut voluptates iste quisquam ut.
Quae voluptatem et et tenetur ipsam. Labore veniam aut reiciendis sapiente earum blanditiis. Quia delectus ut expedita labore eligendi.
Ut maxime excepturi sunt ut id quaerat animi at. Unde quas veniam doloribus natus quia quia. Laborum nostrum doloremque quidem officiis rerum natus. Aliquam laboriosam sed et voluptas ratione nobis non. Mollitia sapiente quaerat possimus dolore qui perferendis.
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...