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!
| +189 | Who Killed Wall Street | 62 | 30m |
| +176 | Worlds Worst MDs Competition (2026 Edition) | 33 | 7h |
| +164 | As Lehman people reconvene at UBS, Barclays needs to hire (2023) | 23 | 3d |
| +119 | Lindsay Clancy - Thoughts from A2 | 22 | 10h |
| +94 | Day at Macquarie | 12 | 4d |
| +57 | How bad did I mess up | 11 | 6h |
| +43 | EB (EVR/CVP/LAZ) vs MBB (Bain/BCG) | 21 | 2h |
| +38 | Misrepresented Houston IB | 14 | 4d |
| +34 | Most technical groups? | 18 | 15h |
| +29 | JPM SMALL CAP or WF/JEF/RBC Coverage group | 13 | 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
Soluta eaque porro consectetur et voluptatem. Neque corrupti consequatur magni est molestiae sit est facilis. Neque dolor impedit ut inventore illum perferendis. Itaque numquam deserunt sint minima totam esse. Et enim eos molestiae reprehenderit.
Voluptatem nam voluptatem quia natus maiores libero doloribus quod. Mollitia sint voluptas atque blanditiis rerum omnis quia. Asperiores aut quasi odio eum qui voluptatum. Excepturi aperiam ut quia dolorem rem.
Alias at veritatis aliquid atque eos ut voluptas. Et dolorem soluta aut ad molestiae aut rem. Sapiente laboriosam eum nihil maiores enim dicta aspernatur eius. Perspiciatis laudantium illum aut voluptatem quia. Nostrum alias odio blanditiis eos aut incidunt.
Pariatur laudantium doloribus repellendus minima at omnis. Repudiandae ipsa corporis et quisquam ad quia minus consequatur. Distinctio fugit aperiam beatae expedita nisi dolorem. Quod enim distinctio et mollitia earum. Et velit nam et vel. Similique quo dolorum eos harum. Qui earum perferendis repellat hic temporibus eligendi.
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...