Forcing imported numbers to text format problem

B

bobthecow

I'm opening up an HTML table in Excel and Excel is formatting my dat
incorrectly, such as turning a code into a date and dropping necessar
leading zeros.

Is there a way to tell Excel to pull everything as Text? Will thi
work in my ASP page that generates the table?

I've seen the quick solution of appending a ' onto the data befor
import, but I dont want to be appending to the data
 
Top