How To Change Pivot Table Number Formats to Thousands

[@Up4Excel]

👉 Up4Excel Downloads Library: »» ml.up4excel.com/library
✅ FREE Access to ALL Up4Excel Files. Includes Excel Templates, Training Workbooks, Example Data, Cheat Sheets and more. New Content Added Weekly!

[@Oksanofabich]

Thank you!! That's exactly what I have been looking for

[@Up4Excel]

Great to hear that 👍 John

[@dillonbarclay8373]

I couldn't find the answer anywhere else, thank you! I ended up using: #,##0,;(#,##0,)

[@Up4Excel]

Thanks Dillon, glad to help 👍

[@johnborg5419]

Thanks John :)

[@Up4Excel]

2 comments on 1 video John :) 👍

[@johnborg5419]

Thanks John. :) :)

[@Up4Excel]

No worries 👍

[@zelonirak3435]

why does my pivot table only show hourly intervals when my time column on excel table are 15 min intervals? time interval values on table formatted: custom hh:mm

[@Up4Excel]

Right click on the field in the pivot tables with the time. You should see Group and Ungroup in the menu - click on this and you get options to play around with. Hope this helps 👍

[@Up4Excel]

📗 Download Your Practice Workbook: »» cutt.ly/up4excel023-1
🎯 Too many digits on a report looks confusing. Get your pivot table numbers looking presentable by changing them to show in thousands....I'll show you how.

[@DPaquette]

How To Change Pivot Table Number Formats to hundreds

[@Up4Excel]

There's no number format for hundreds but you could add a column to the source data to divide everything by 100.