Help displaying leading zero

[4345487]

Hi,

I have a text field that is use for the zip code when the field is stored in the database it has a leading zero.
example 01234. The problem happings when I used

Response.ContentType = "application/vnd.ms-excel"

to create a excel report the leading zero don't displays
so the number above displays 1234

any help will be appreciated

Thanks

 

[Bullschmidt]

How about putting double quotes around the data in that field perhaps something like this:
Response.Write Chr(34) & objRS("ZipCode&quot & Chr(34)

Best regards,
J. Paul Schmidt

http://www.Bullschmidt.com

- Freelance ASP Web Developer

http://www.Bullschmidt.com/DevTip.asp

- ASP Web Developer Tips

 

[4345487]

I get it to work doing this


<td>&nbsp;<%=TestRs(&quot;Zip&quot%></td>


Thanks for all you help

 

[4345487]

I'm sorry this way


I put a space between the td tag and the valye using the
&quot;nbsp;&quot; like below with out the double quotes

<td>&quot;nbsp;&quot;<%=TestRs(&quot;Zip&quot%>

 

[Bullschmidt]

Oh yes and just for future reference, here is another approach:

To pad with leading 0's up to 5 digits:
varFld = Right(&quot;00000&quot; & varFld, 5)


Best regards,
J. Paul Schmidt

http://www.Bullschmidt.com

- Freelance ASP Web Developer

http://www.Bullschmidt.com/DevTip.asp

- ASP Web Developer Tips