|
|
Posted by Mark Parnell on 06/07/06 06:46
Deciding to do something for the good of humanity, Gobi
<nospam@nobody.com> declared in alt.html:
> What my problem is, one of the
> columns has IDs that has zeros in front (eg. 00001). In the html table,
> it is displaying fine. But in the excel table it strips the zeros so
> now my id is 1 when in fact I still want to display it as 00001.
Adrienne is on the right track. You need to somehow tell Excel to treat
the cell value as a string instead of an integer. If putting quotes
around it doesn't help though, I don't know how you'd achieve that.
--
Mark Parnell
My Usenet is improved; yours could be too:
http://blinkynet.net/comp/uip5.html
Navigation:
[Reply to this message]
|