Skip to Content
-1

Data Type Declaration - issue while downloading into excel

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,

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Mar 08, 2017 at 12:46 PM

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

    Add comment
    10|10000 characters needed characters exceeded

  • Mar 08, 2017 at 12:56 PM

    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!!

    Add comment
    10|10000 characters needed characters exceeded