For example, your numerical values might be formatted as accounting, or currency, that formatting is not carried over to the body of the pivot table.
There is one limitation and that is that when you create a pivot table based on the data source that has formatting applied. Pivot tables are extremely powerful and that they allow you many different ways to gain insights into your data.
