AnsweredAssumed Answered

Turning Off Scientific Notation for a Given Field

Question asked by MichaelArnovitz on Jun 2, 2011
Latest reply on Jun 3, 2011 by MichaelArnovitz

Title

Turning Off Scientific Notation for a Given Field

Post

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.
Michael 

Outcomes