Turning Off Scientific Notation for a Given Field
This seems like something that should be simple, but I cannot get it to work.
I have a field which contains a long ID number, typically 9-15 digits. Whenever I import the data into this field many (but oddly not all) of the records change this ID to scientific notation, and I cannot get FP to stop doing this.
I have tried changing the field from number to text: still does it. I have tried changing the number format of the field itself to "as entered": does it less but still does it. I even tried a calculation: again works on some but not others.
How do I get FP to allow this field to display a number, regardless of length, without changing it to scientific notation?
Thanks in advance for any insight.