Is there a way to prevent Character to Number conversion

  • Thread starter Thread starter joeonetime
  • Start date Start date
J

joeonetime

I use a web application that displays data in HTML tables in a we
browser. I would like to save the HTML files locally, and open them i
Excel.

Excel takes all of the fields which contain numbers, and coverts the
to numeric fields, even if they are intended to be character fields.

This causes a problem for me - in that Excel will trim leading zero
(from labeler codes, and UPC's) - which I *don't* want to happen.

Is there an option or setting that I could use in Excel that woul
prevent it from doing this conversion when I open these HTML files?

Thanks in advance
 
Back
Top