I'm new to this list and also new to MS Lists being a long time Excel user.
I'm wondering if anyone in this discussion group has some insight into the issue that if a field with a numeric value is automatically loaded into MS LISTS, it concatenates the number values to 5 decimals. 117.47584758347 to 117.47584
Is there an option for changing the default from 5 decimals to an agency chosen default value?
If I am using a Geographic Location X, Y value for mapping purposes, I want to be sure the full decimal is not lost.
If you choose the LOCATION Type, it works, however, this requires knowing you can't just import the table without choosing the correct types for each field and treating like a text value. This is not a good resolution.