Problem when exporting to Excel 2002. The percentage column loosing format

[katdbc]

   
   Problem when exporting to Excel 2002. The percentage column loosing format
Posted: Jun 19, 2012 12:08:08 AM         
Click to report abuse...         Click to reply to this thread    Reply
Attachment    export issue.bmp (1.0 MB)
Hello

I have a report studio cross tab report which has a percentage column, formatted as "percent" by two decimal places.
The calculation for the column is (count(a)/count(b)).

When the report is exported to excel 2002 or even CSV, it looses its formatting.

for example :33.33 % in HTML is exported as .33 % ,38.10 % is exported as .38 %,100% exported as 1.00 %.

I have attached a snapshot about how it looks in the HTML and Excel.

I am using a Cognos 10.1.1 and Using DB2.

Any help would be greatly appreciated.