This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
When I am downloading a .csv file from my base when opening the file in Microsoft Excel some of the data is missing/changed. The field that is having the issue is a linked field that lists numbers from an autonumber field. It seems that after 5 sets ...
After doing some researching on Excel, I figured out that Excel has a limit of 15 significant numbers and any number after that will be a 0. Changing the field type to text type changes the data to scientific notation messing the data up even further...
