How can I get rid of the ' single quote sign in excel worksheet

[Guest]

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

 

[Anne Troy]

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

 

[Shatin]

See if the following works:

- In an empty cell type the number 1.
- CTRL-C to copy this number.
- Place the cursor anywhere in the table.
- CTRL-* to select the whole table.
- Choose from the menu Edit>Paste Special.
- Under operation, choose Multiply, click OK.

 

[Guest]

Dear Anne,

Thanks a lot! The information is very helpful!

Ivan

 

[Guest]

Dear Shatin,

Thanks for your help! Your method also works. Unfortunately my worksheet has
some date cells, they all changed to numbers after the operation.

Ivan

 

[Anne Troy]

They don't really change to numbers, Ivan, they just change to number
FORMAT. If you want more information on this (maybe you don't need it now,
but for future), see:
http://www.cpearson.com/excel/datetime.htm#SerialDates
************
Anne Troy
www.OfficeArticles.com