Prevent Export from Excel "Number as Text" Reformat to Scientific Notation

Asked Oct 22 '13 at 18:38

Active Oct 22 '13 at 18:38

Viewed 865 times

I'm trying to export data from Excel, and one of the columns is populated with IDs that often look like large numbers. For example, one cell will contain : 100,200,300,330,430,500... I am trying to export this data into a string variable using VB.NET, but whenever the number is large enough, the value converts to scientific notation.

I've checked out the second solution at this link, but I'm hoping the code I'm already using can be tweaked instead of having to rewrite using OleDB.

The code I use for the problem cell is this:

importData.Predecessors = cellRange(1, CInt(fieldMapping.Predecessors)).Value

edited May 23 '17 at 11:50

Community

asked Oct 22 '13 at 18:38

user

1,261
2
21
43

1

Instead of Value, do you have a property for Text? – the_lotus Oct 22 '13 at 19:16
That worked wonders. I didn't realize "Text" was an option since it didn't come up in intellisense. – user Oct 22 '13 at 19:24

Prevent Export from Excel "Number as Text" Reformat to Scientific Notation

0 Answers0