Data showing incorrect when sending or exporting to excel from table box

[#1]

Hi,

  I have data in table box as below

Data in table box
3536332219437005
6356536120134009

when I am sending or exporting to excel the data is changing as below

Incorrect
3536332219437000
6356536120134000

and sometimes it is showing as 3.9E+15

How to make data as it is even though if I send or export to excel? can anyone suggest me please.

Thanks.

[consenit]

Hi there.

Try setting your desired numeric format for the field on the "numbers" tab before exporting.

Kind regards,

Ernesto.

[#3]

Sounds like excel automatically formatting rather than something Qlikview is doing to be honest. Look to adjust the format in Excel maybe

[#4]

Thanks. I tried all but nothing working. Any help please to set in Qlikview script itself.

[#5]

Thanks. any help please in number tab?

[Anonymous]

Hello,

As I wild guess, it should be related to Excel's number handling.

There is probably a difference between QlikView's number standards and Excel's. So you can search on that.

You know there are different standards on floating point, by that rationale I guess it is the same with large numbers.

BR

Serhan

[Anonymous]

Looks like a precision limit in excel.