locked
Export Grid View in Excel RRS feed

  • Question

  • Export GridView to Excel is working Fine But My problem is when excel open the
    file, it became numeric, this may cause problem, cause the field is a credit
    card number (e.g 1234567812345678 ), the excel will show 1.23457E+15, and the
    actual value became 1234567812345670, that is totally wrong
    Sunday, December 1, 2013 4:11 AM

Answers

  • I think if you append an apostrophe to the credit card number Excel will know you mean text instead of a number:

    '1234567989000897


    Bob - www.crowcoder.com

    Sunday, December 1, 2013 3:30 PM