Hi, I'm importing data with a column for paragraph numbers, eg 7.5.13, 8.6, etc. PQ seems to recognise the first value as text and the second as a number. Occasionally, 8.6 will get corrupted and appear as 8.59999999999999999999999. I'd like to know if there's something I can do about this, that's easier than going through the whole column and manually replacing the values. Is this a bug in PQ? If this error is unavoidable, is there a function I can use to round these errors? TIA...
Hi Paul,
The problem you're discovering happens when Excel converts values to binary and back again. Sometimes referred to as a floating point.
Without seeing the structure of your file it's tricky to give a specific solution, but I would use Round to round the values to 2 decimal places.
Hope that helps. If you're still stuck, please provide a sample Excel file so we can insert the solution in the file.
Mynda
Thanks Mynda, I don't know if rounding to 2 decimal places would work: 5.6 would appear as 5.60, for example. At present I'm extracting from several Excel files in a folder, and from multiple sheets in each file. I tried replicating the issue from within a single file, ie, the source data and the query in the same file, but I can't replicate the error. Paul
How about rounding to 1 decimal place then?
