Importing a decimal number

[k0r54]

Hi,


I have the field set to number -> decial and places to 2.

The CSV document reads 96.133542682

So once imported it should look like 96.13

but it doesn't it is just 96.

Why is this? when the field is text it is the 96.133542682 as it should be.

Thanks
k0r54

 

[k0r54]

mmm, any idea?

 

[Rich]

Is it Single or Double format in your table and not Integer?

 

[k0r54]

no, it was set to decimal, but i have changed it to both of them and it still does not work.

Thanks