keep formatting in pivot
 

How do I keep the formatting for numbers in a pivot table after I have
refreshed it? I have already tried to do this by changing the "table option"
by unchecking the "auto formatting" and checking "perserve formatting", and
this didn't work. Can you someone please help?

Thanks!