Data Type Declaration - issue while downloading into excel

[former_member225134]

Hi All,

Am using this field in report AUBFSTR-EKWRT curr 17..in alv report output

it is displayed as 249,999,999,999,999.75 . After that am downloading from alv report to

excel it is displaying as " 250,000,000,000,000.00"... Inside that program am writing

code for excel download and trigger in mail ,here am getting the value as 249,999,999,999,999.00 .

So what is the difference here it is downloading in different values..

How can i display the original value 249,999,999,999,999.75 in excel ...

Any suggestion please.

Regards,

[former_member225134]

Those are limits of Excel usually Number precision is 15 digits for recent versions. Look at IEEE 754 and online documentation for your version)

[RaymondGiuseppi]

Those are limits of Excel usually Number precision is 15 digits for recent versions. Look at IEEE 754 and online documentation for your version)

[Sandra_Rossi]

And also more general litterature about "maximum number of significant digits": https://en.wikipedia.org/wiki/Significant_figures

[Former Member]

Hi,

I think you are exceeding the numerical value that excel supports for a particular cell. If you delete some 9's from the number then you will see that the numbers are coming in proper format.

I have deleted some 9's from the number and tried with this number: 2499999999.75. The output was coming properly.

Hope it helps!!