Export to Excel using ASP.

Question

Hi,

At the time of exporting to excel using ASP. After converting a column in text format single quote is visible in the excel file. how to hide this automatically ?

Answer 1

You might be helped by setting the style of your cell to mso-number-format:"\@", but I'd have to see your code to know the exact problem.

I think you might find Styling Excel cells with mso-number-format and Generate Excel files in ASP Classic useful.

Answer 2

When you export to excel, you could juste make a table with cell, and put your value into double quote. Excel will read it correctly