*Unbelievable Excel Update!* Pivot Table numeric formatting is now automatically coming from the grid!
Microsoft didn’t announce this (that I’ve seen), but it just *worked* this morning. No more manually formatting numbers in your Pivot Tables—Excel is pulling it straight from the source data. 
Thousands separator? 
Currency symbols? No extra steps? Watch as I demo this game-changing update with a quick dataset. This small but mighty improvement is a *huge* win for efficiency!
Have you seen this in your version of Excel yet? Let me know in the comments! 
**Subscribe for more Excel tips!** 
**Like this video if this saves you time!** Thanks for watching—see you next time for another net cast from MrExcel!
Table of Contents
(0:00) New pivot table improvement
(0:10) Source data number formatting
(0:20) Appears automatically in the pivot table
This video answers these search terms:
Excel Pivot Table Number Formatting Update
Automatic Number Formatting in Excel Pivot Tables
Excel Pivot Table Formatting from Source Data
New Excel Pivot Table Feature 2025
Excel Pivot Table Tips and Tricks
Transcript of the video:
Unbelievable. The pivot table...
numeric formatting is now coming from the grid. It was not announced by Microsoft that I've seen.
But it just worked this morning. Here's a dataset.
This quantity with a thousand separator, no currency symbol.
These have currency symbol, no decimal places.
Watch this. Insert, Pivot table.
Going to a brand new sheet. I do no formatting to this sheet.
Let's put Customer down the left hand side. Quantity shows up with the comma.
Revenue, Cost of Goods, Sold, and Profit show up with the currency.
It's coming from the underlying data. What a great, amazing day this is.
Just getting the number formatting is amazing. I want to thank you for stopping by.
We'll see you next time for another net cast from MrExcel.
numeric formatting is now coming from the grid. It was not announced by Microsoft that I've seen.
But it just worked this morning. Here's a dataset.
This quantity with a thousand separator, no currency symbol.
These have currency symbol, no decimal places.
Watch this. Insert, Pivot table.
Going to a brand new sheet. I do no formatting to this sheet.
Let's put Customer down the left hand side. Quantity shows up with the comma.
Revenue, Cost of Goods, Sold, and Profit show up with the currency.
It's coming from the underlying data. What a great, amazing day this is.
Just getting the number formatting is amazing. I want to thank you for stopping by.
We'll see you next time for another net cast from MrExcel.
