error while running the report in excel 2002 format

[katdbc]

I have a report which shows proper values when i run in the html format. but when i run the report in excel 2002 everything looks good  except the summaries for few of the columns for which it appears as zero.The summaries are percentages and when i click the 0 in the excel, i see the actual value in the formula bar.eg: if its -14% in html, then the value in the formula bar will be .14

so in the data format: I gave the % symbol with number of decimal places: 2

I have attached the snap shot with both html and excel.

how should the data format should be.have any one faced this problem

Any help will greatly be appreciated.

Thank you

[PRIT AMRIT]

Just remove the data format and run the report in excel and see how it appears?

[joecog]

Sometime put a 2 at the solve order would help also...