Hi Beni, I did use the number format.. But when I refreshed it goes back to original setting...
I even did this...
1. Pivot table option => Check the Preserve cell formatting =>Ok
2. Option => Enable Selection
3. Highlighted all the data => format cell to numbers.
4. Refresh
The numbers format did not update... What could I have done wrong?