Solved
Forum Discussion
joseph_michaud
Staff
10 years agoUse .Text instead of .Value when reading the cell, ie
array1(i) = xlsheet.Cells(row,i+1).Text
This link helps understand it a bit more:
Colin_McCrae
10 years agoCommunity Hero
joseph_michaud ... handy to know. I wasn't aware of the ".text" property.
(Everything on my spreadsheets - and I use a LOT of them - comes with a letter prefix to indicate what the data should be used for. So everything is treated as strings. Keeps it simple!)