"wrong" format from odbc connection

[#1]

Hi!

I've just made an odbc connection and found a field which are presented like this;

2,1102830595096e+016

instead of;

21102830595096

in the database data in this filed looks as it suppose to but when importing it to qlikview it changes.

What do i do to correct this? (it's a bigint in the database)

Thanks in advance!

//A.

[gandalfgray]

Settings > Document Properties > Number

Mark the field and specify the Number Format Setting to whatever you want,( Integer for example).

[#3]

Tried hat already, didn't work. 😞