Hi,

I am using vb.net and excel automation to copy a dataset from my window app
to excel. I copy the data to the clipboard and then paste into an excel
worksheet in a particular range. The problem I have is that one of my
columns contains phone numbers in the following format +4478106356546.
Because of the "+" all the numbers in that column is displayed something
like 4.47811E+15. I would like to format that column and tell it display
it's values as text. Does anyone know how to do this or have any other
ideas.

Thanks
Sumesh

Format the column as text before you paste.

--
Regards,
Tom Ogilvy

"Sumesh" wrote in message
...
Hi,

I am using vb.net and excel automation to copy a dataset from my window
app
to excel. I copy the data to the clipboard and then paste into an excel
worksheet in a particular range. The problem I have is that one of my
columns contains phone numbers in the following format +4478106356546.
Because of the "+" all the numbers in that column is displayed something
like 4.47811E+15. I would like to format that column and tell it display
it's values as text. Does anyone know how to do this or have any other
ideas.

Thanks
Sumesh

Thanks for the quick reply.
How do I format the column as text? As I mentioned the dataset is changed
into a tab delimited string, which I copy into the clipboard which I paste
into excel. So I don't how I can change the format to text. I can only think
of changing the format after I paste to excel.
Appreciate your thoughts or ideas.

Thanks
Sumesh



"Tom Ogilvy" wrote in message
...
Format the column as text before you paste.

--
Regards,
Tom Ogilvy

"Sumesh" wrote in message
...
Hi,

I am using vb.net and excel automation to copy a dataset from my window
app
to excel. I copy the data to the clipboard and then paste into an excel
worksheet in a particular range. The problem I have is that one of my
columns contains phone numbers in the following format +4478106356546.
Because of the "+" all the numbers in that column is displayed something
like 4.47811E+15. I would like to format that column and tell it display
it's values as text. Does anyone know how to do this or have any other
ideas.

Thanks
Sumesh

Columns(2).Numberformat = "@"
do the paste

--
Regards,
Tom Ogilvy

"Sumesh" wrote in message
...
Thanks for the quick reply.
How do I format the column as text? As I mentioned the dataset is changed
into a tab delimited string, which I copy into the clipboard which I paste
into excel. So I don't how I can change the format to text. I can only
think
of changing the format after I paste to excel.
Appreciate your thoughts or ideas.

Thanks
Sumesh



"Tom Ogilvy" wrote in message
...
Format the column as text before you paste.

--
Regards,
Tom Ogilvy

"Sumesh" wrote in message
...
Hi,

I am using vb.net and excel automation to copy a dataset from my
window
app
to excel. I copy the data to the clipboard and then paste into an
excel
worksheet in a particular range. The problem I have is that one of my
columns contains phone numbers in the following format +4478106356546.
Because of the "+" all the numbers in that column is displayed
something
like 4.47811E+15. I would like to format that column and tell it
display
it's values as text. Does anyone know how to do this or have any
other
ideas.

Thanks
Sumesh