Format Pivot Table values display as Million, Thousands

Описание: When we analyze large numbers / datasets (especially related to financials), the default number formatting in Excel does not show up to the mark in pivot tables.


One trick can be use to format custom number in Excel (Ctrl+1), to show numbers in “millions.”


Format: #,, "Million"

Note: The 2 commas after the format - this scales the number down by a factor of a thousand for each comma.


#Excel #Exceltips #eLearningPlus