Forum Discussion
tristaanogre
15 years agoEsteemed Contributor
Personally, I've found that a best practice is to make sure all your data in the Excel sheet is a string. Makes it a lot easier to standardize the file.
From there, using StrToInt or VarToInt are the best rules that I've found that, if you want to make sure a data value from the spreadsheet is treated as an integer, explicitly convert it.
From there, using StrToInt or VarToInt are the best rules that I've found that, if you want to make sure a data value from the spreadsheet is treated as an integer, explicitly convert it.