Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2004
    Location
    Oslo
    Posts
    45

    Unanswered: Response.Contenttype with Excel/IE -> removing zero's (o) from column ??

    hey and thanx for reading my post..
    hmm. i'm using "Response.Contenttype="application/vnd.ms-excel" to display a recordset in Excel (inside IE).

    Only problem left is that (annoying) Excel are automatically removing the Zero's (0's) in a column which displays social security number. Anyone know a work-around ?

    Terje.
    Best regards
    Mirador

  2. #2
    Join Date
    Nov 2003
    Location
    Christchurch, New Zealand
    Posts
    1,618
    is it leading zeroes that it is removing?? if so I would recommend writting the SSN out with single quotes around it. This way excel will treat it like a text value and not a numeric value

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •