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.