Leading Zero dropped in Excel spartan2004-12-29 04:33:06

when I export data from oracle (text field) to Excel using asp, all the leading zeros are dropped. i used "'"& rs("field_name") and
format(rs("field_name"),"0000000099999") , they are still missing zeros. help please!

Try save them as text, not num

No use, Excel will not take it