Can any one help me, I want bind the value starting 0 (eg;-00123) in Excel file from vb.net
if IsDBNull(DSResultset.Tables(0).Rows(IRowCount).Item("ChequeNo")) Then
lstchqNo = ""
Else
lstchqNo = DSResultset.Tables(0).Rows(IRowCount).Item("ChequeNo")
End If
sw.Write(lstchqNo)
sw.Write(vbTab)
0's are truncated by using above code while binding in excel