i want to display 0.00 for null values in pivot view.so i used customer format - #,#.0;-#,#.0;0.00 to display it. but issues is when i export report output to 2007+, all values which are updated with 0.00 from null are showing as text. Anyone suggest me how can i fix this?