Forum Discussion
helms1016
Sep 07, 2022Copper Contributor
Import numbers are rounding
When I import a report from our membership software online the membership number (16 digit number) rounds to the nearest tenth. The column width is fine and the number does not have any decimal plac...
Martin_Weiss
Sep 08, 2022Bronze Contributor
Hi helms1016
Excel has a calculation limitation of 15 digits. So more than 15 digits will be ignored / replaced by 0.
In your case, a possible solution would be to import the membership numbers as a text instead of numbers.