Problems with small numbers in Query and in XL pivot table

[Leon Noel]

Hi,
I have some CSV data that I want to use in a Pivot Table:
I'm accessing the data from XL through MS Query using the MS text driver.
I have a field named 'Ratio' with significant digits up to the ninth decimal
place.

Ratio
0.000118019
0.0000012
0.0000014
0.0000028
0.000001488

But, ... in Query and in Excel, everything is showing up as zero.
How can I get the correct number to display and calculate in the Pivot Table
?

TIA

Leon

 

[Ardus Petus]

Works by me. No data loss.

HTH

 

[Leon Noel]

The problem has disappeared now that I have formatted the numbers witha
fixed size.
As you can see in the original example some of the numbers are longer than
others.
Apparently MS Query needs them all to be the same length.
Now that they all have 9 digits after the decimal, with trailing zeroes
wherever needed, Query and XL are much better behaved.
Nothing like a bit of discipline, What ??!!

Leon