Pivot Table Not Displaying Number Format Correctly

[legalhustler]

The following amount displays in a cell:

0000000000253585952

When I click in the cell, the formula bar shows it as 253585952.04. This is displaying correctly for my purpose.

However, when I do a pivot table it displays $25358595204 instead of $253585952.04


How can I fix this?

 

[snipescc]

Highlight the column and change the number formatting. either use the button on the home tab, or right click and pick number formatting. Take a peek to see if it is set to a custom format, which might explain the leading zeros.

 

[legalhustler]

Highlight the column and change the number formatting. either use the button on the home tab, or right click and pick number formatting. Take a peek to see if it is set to a custom format, which might explain the leading zeros.

Leading zeros are okay, bc that's the original data format. I applied a VB code to multiply the amount by .01 and it display the correct amount in the formula bar. When I try to create the pivot table the number format does not display the amount with the decimal point. See my previous thread:

http://www.mrexcel.com/forum/excel-...plications-multiply-entire-column-number.html