HTML to Excel: preceding 0's disappear?!
 

I have a table in an HTML file
There is a column of data with values like 01, 02, 003...
i.e.
.....
<tr<td01</td</tr
<tr<td02</td</tr
<tr<td003</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
HIS


"yung" wrote in message
...
I have a table in an HTML file
There is a column of data with values like 01, 02, 003...
i.e.
....
<tr<td01</td</tr
<tr<td02</td</tr
<tr<td003</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