Dear Pris,

Try this:

Right Click on the Pivot Table
Select Pivot Wizard
Layout
DATA-Double Click
Select Number
Select Custom
Type: #.####################### (23 characters for buffer)

Click OK.

If it is Value (not text), it should work.

Hope this helps!!