I have spent a lot of time trying to figure this out in excel. The issue is my Number column in excel displays scientific number;
I have used the format cells to numbers but when I save and reopens the scientific numbers comes back.
This is an issue when using the csv as a search layer. It gives random numbers.
I want the unique numbers to be displayed as it is..
At the moment my info table displays 100090429671 as 1000000000000.