Skip to Content
-1

Data Type Declaration - issue while downloading into excel

Mar 08, 2017 at 09:37 AM

37

avatar image

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,

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

Raymond Giuseppi
Mar 08, 2017 at 12:46 PM
1

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

Show 1 Share
10 |10000 characters needed characters left characters exceeded

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

0
avatar image
Former Member Mar 08, 2017 at 12:56 PM
0

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

Share
10 |10000 characters needed characters left characters exceeded