Leading Zero dropped in Excel

来源: spartan 于 2004-12-28 20:33:06 [] [旧帖] [给我悄悄话] 阅读数 : (231 bytes)

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 -ExcelExprt- ♀ 给 ExcelExprt 发送悄悄话 (0 bytes) () 12/29/2004 postreply 05:01:56

• No use, Excel will not take it -spartan- ♀ 给 spartan 发送悄悄话 (0 bytes) () 12/29/2004 postreply 08:00:06

请您先登陆，再发跟帖！