Hi all - I've been using format cycling like the below for my formatting
#,##0" ";(#,##0);"– "
#,##0%" ";(#,##0%)" ";"– "
However, I recently learned about the "_" option and now use in my custom formatting
#,##0_);(#,##0);"–"_)
#,##0%_);(#,##0%)" ";"–"_)
Just wondering what is the "most correct" formatting to use in Excel? Is my second option correct?
| +127 | UBS Americas IB: The Kids’ Table of Wall Street | 15 | 2d |
| +99 | Return Rates For Interns Are Falling? | 36 | 33m |
| +64 | London IB BB is a challenge | 38 | 13h |
| +58 | VP Lifestyle at Top BB Coverage Groups | 36 | 55m |
| +55 | I am a drunk MD AMA | 30 | 49m |
| +46 | SharePoint makes IB hours HELL | 15 | 1d |
| +46 | An Outsider’s View of RX Banking Out of College | 6 | 15h |
| +41 | momentum of Rx groups | 13 | 12h |
| +38 | Fired during interview | 7 | 15h |
| +28 | Most Technical Groups Ranked | 13 | 12h |
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.
Temporibus vel autem sunt voluptas laborum est dolor. Modi officia veniam soluta est consectetur similique.
Iste enim soluta blanditiis ut rem optio. Non et soluta debitis ea accusantium omnis. Quo consequatur et perspiciatis deserunt qui.
Ut aut amet tempora et pariatur pariatur est. Corporis nam non commodi vel assumenda et. Sunt veniam expedita ex sed dolor.
Eos hic consequuntur voluptas. Accusantium aut atque corporis in quia. Maiores laudantium mollitia voluptatem excepturi.
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...