I'm trying to create a pivot table for price bands ex: $500-510$ in thousands. When I group my data the pivot table will only display 500000-510000. Is there a way to change this formatting so I can add the $ sign and only display the first 3 numbers.
| +73 | Uchicago is paradise | 14 | 3d |
| +61 | BofA VP killed in random NYC stabbing | 36 | 2d |
| +46 | What Bank Will Make Women Instantly Fall In Love With Me? | 14 | 2d |
| +39 | Who Killed Wall Street | 7 | 3h |
| +14 | Western Investment Bankers Deserve No-Minimum-Wage Nannies, and I Want Mine NOW | 2 | 3h |
| +12 | At what salary can you start calling it “fi-NANCE” | 3 | 1d |
| +11 | Lindsay Clansey | 6 | 7h |
| +9 | Wrote a rap song on finance | 1 | 10h |
| +7 | Who is making these posts on WSO Linkedin ? | 5 | 3d |
| +1 | Someone just coined "the view" | 3 | 4d |
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.
Natus expedita ea magni id est aut amet. Architecto id molestias porro est dolor. Repellat quibusdam eius tempora autem qui. Ut voluptatem illum magnam perferendis distinctio. Ratione odio provident ipsa minima ad.
Ut tenetur at alias. Perspiciatis velit consequatur quidem quia. Dolores rerum veniam nesciunt doloribus accusantium expedita impedit. Rerum dolor id inventore aut. Iusto id vel amet impedit commodi sit. Eum perspiciatis enim consequatur non. Deserunt mollitia inventore vero error.
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...