HTML to Excel: preceding 0's disappear?!

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
 
N

Nick Hodge

Yung

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

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Extracting HTML from web based query? 1
opening html table in Excel makes preceding 0's disappear??!! 1
How to pass an html td onclick event value in wcf service url forkendo ui in asp.net application? 0
Open HTML in Excel 1
Looping through HTML table to populate Excel 6
Button not appearing in DataGrid column 1
Excel TRIM() can't handle &nbsp; in pasted HTML 2
The code behind file seems to work very strange 2

Top