Click here to Skip to main content
14,981,862 members
Please Sign up or sign in to vote.
5.00/5 (1 vote)
See more:
hi all,

i have a problem in my project while converting a html table to excel sheet a column contains numbers.after converting into excel sheet the column(Zip Code) containing numbers starting with Zero is coming with zero as starting

for example

0123 is coming as 123

can any one solve for me....
thanks in advance.
Posted

1 solution

You need to add a number format to the cell as described here[^], or prefix the value with a ' (single quote), which forces Excel to treat it as text.
   
Comments
madan b 31-Jan-12 8:23am
   
thats single quote works fine thank you Richard MacCutchan
Richard MacCutchan 31-Jan-12 8:28am
   
Happy to help.
Tech Code Freak 1-Feb-12 3:41am
   
Good Solution! 5up!

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)




CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900