Change in cell format when saving to excel

[Former Member]

I'm a new Business Objects user. Since my upgrade to Office 2007, every time I save my report in excel one of the columns containing numbers that are displayed as text (ie 002895, 295512, etc) in desktop intelligence are being displayed as numbers with commas and 2 decimal places in excel and I am losing the zeros at the beginning of the numbers. I have tried formatting the rows in desktop intelligence under the formatting tab as standard, custom, numbers, etc but the formatting of the cells still results in the numbers with commas and decimal places. Can anyone help?

[Former Member]

Hello,

as you refer to Deski I recommend to post this query to the [BusinessObjects Desktop Intelligence|; forum.

This forum is dedicated to topics related to the creation and design of Desktop Intelligence documents such as universe connectivity, prompts, charting, formatting, filter, and formulas.It is monitored by qualified technicians and you will get a faster response there.

Also, all Desktop Intelligence queries remain in one place and thus can be easily searched in one place.

Best regards,

Falk