topic Re: Xl values format in Application Development and Automation Discussions

Xl values format

Former Member — Mon, 03 Aug 2009 07:41:36 GMT

I am sending a email with XL attachement from a report , When opening the XL some values are showing as example : 59900+E000

what changes are needed to see the value as 5999900000000 .

Former Member — Mon, 03 Aug 2009 07:51:41 GMT

Hai,

Its not an issue with SAP-ABAP, It is coming because the Lenthh of your document number is so Long,

Just Double click on the Cell header , It will display values in same format as you want.

Former Member — Mon, 03 Aug 2009 08:03:43 GMT

Hi chari,

that depends on what further calcualtions/operations you want to do with these values.

If it's just a matter of displaying values, you should format these cells as text.

Regards

REA