Forum Discussion

AdamKeever1's avatar
AdamKeever1
Qrew Commander
5 years ago

Why is Quickbase messing with my numbers field on import?????

I have checked, double checked, and triple checked (copy and paste into text editor and copy and paste as text into Excel) and my numbers field contains a list of numbers with two decimal places ONLY. Yet when I import this list of numbers Quickbase changes some of the numbers to many decimal places.

Text editor:


Excel:

Quickbase:

What is the deal!?!

------------------------------
Adam Keever
------------------------------
  • AustinK's avatar
    AustinK
    Qrew Commander
    5 years ago
    I wonder if this is similar to the issue of adding 0.1 to 0.2(or other numbers) in programming. Where you think that 0.3 would be the answer but it isn't, it is 0.30000000000000004 because of the way numbers are stored as floating points and could be looked at as being very precise or lacking precision depending how you look at it. This looks to be similar to that but I assume it is a bug that it is importing in this way. It is basically showing you the floating point of the number rather than what you gave exactly, I think.