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

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

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 EditPaste Special.
- Under operation, choose Multiply, click OK.

"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

Dear Anne,

Thanks a lot! The information is very helpful!

Ivan

"Anne Troy" wrote:

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

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

"Shatin" wrote:

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 EditPaste Special.
- Under operation, choose Multiply, click OK.

"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

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

"Ivan" wrote in message
...
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

"Shatin" wrote:

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 EditPaste Special.
- Under operation, choose Multiply, click OK.

"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