Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Opening an Excel file | Excel Discussion (Misc queries) | |||
quattro pro converter Excel 2003 | New Users to Excel | |||
other systems detecting excel 4.0 if excel 2000 is installed | Setting up and Configuration of Excel | |||
Using Excel to analyze HTML | Excel Discussion (Misc queries) | |||
HTML to Excel | Excel Discussion (Misc queries) |