Hi, Ivan. Follow the instructions he
http://vbaexpress.com/kb/getarticle.php?kb_id=109
Save the code in your personal.xls file:
http://www.vbaexpress.com/forum/arti...ticle&artid=18
************
Anne Troy
www.OfficeArticles.com

"Ivan" wrote in message
...
Dear all,

I am not sure if I am posting my question in the right page, I hope
someone
can help me out.
I used the DTS package in SQL server to put a table's table on an Excel
worksheet. However, I discover that a single quote " ' " is placed in
front
of the values in every cell. This makes the calculation or format change
cannot be carried out. How can I get rid of the single quote? I am so
frustrated.
Thanks.

Ivan