HTML to Excel: preceding 0's disappear?!

  • Thread starter Thread starter yung
  • Start date Start date
Y

yung

I have a table in an HTML file
There is a column of data with values like 01, 02, 003...
i.e.
.....
<tr><td>01</td></tr>
<tr><td>02</td></tr>
<tr><td>003</td></tr>
.....
When I open it with Excel, all the preceding 0's disappear (i.e. they become
1, 2, 3, ... )
How can I show the original data with all the preceding 0's kept unchanged?

Thanks!!!


Yung
 
Yung

and a single apostrophe to the front in the HTML (')

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
(e-mail address removed)
 
Back
Top