Leading Zero dropped in Excel

来源: 于 2004-12-28 20: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!