Hello - currently working on a project where I import data from an .xlsx file then run some macros to massage the data, and ultimately load to a sql table.
This morning I noticed that one of the longer numeric fields, which contain 19-25 digits, is being modified and I'm not sure how to get around it.
The column containing the number is in GENERAL format when I open the file (so it displays in scientific notation), and I change it to NUMBER in the macro with
Columns("Q").NumberFormat = "0"
When I look at the source file in NOTEPAD ++ it shows "6585341937000906783" but in my spreadsheet, and when I use that cell to feed into my variable, it's changed to "6585341937000900000" (the last 4 digits are 0's, always)
How can I keep the value of the numbers when it seems to be modified when the file is opened?
Thanks for any tips/advice!
Bookmarks