C
Clark G.
I am loading an HTML table. One of the columns is a list of 4 character
department numbers. A valid department number could be 83E1, but when I open
the HTML table file in excel, any department that has a standing E in the 2nd
or 3rd character of numbers get interpreted as being scientific notation and
is converted (8.30+E2). I want Excel to IGNORE this conversion! And I
can't simply get it back to 83E1, because if I make 8.30+E2 a text column, it
converts that number to the string 830.
department numbers. A valid department number could be 83E1, but when I open
the HTML table file in excel, any department that has a standing E in the 2nd
or 3rd character of numbers get interpreted as being scientific notation and
is converted (8.30+E2). I want Excel to IGNORE this conversion! And I
can't simply get it back to 83E1, because if I make 8.30+E2 a text column, it
converts that number to the string 830.