Missing Number formating

[agni_gold]

Hi Friends,

I have one pivot table in which I have done suppress zero value, now in the place of Missing Values I have written 0.0, but when I exporting table to excel, then it's 0.0 will come in text format, and other will be in number format,

How can I get all number in number format?

[rwunderlich]

When you say "they are already 0 from the script", do you mean you have generated zero values for every possible combination in your pivot table? 

-Rob