Skip to Content
0
Former Member
Jun 26, 2009 at 03:10 PM

Change in cell format when saving to excel

15 Views

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?