Skip to Content
0
Aug 15, 2011 at 07:49 PM

Excel export Issue

18 Views

Hi,

BO Version: XI R2

Excel Version: 2007

My question: When I export a WEBI report to excel, the cells with 0 in my report are being exported as Text in the spreadsheet. Is this a common behaviour, what is the fix.

Ofcourse, I can Convert the 0 cells from Text to Numeric, but Can't expect each user to do it manually. There should be a solution to this problem.

Any suggestions.

Thankyou.