format +44785656656 as text
 

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 +44785656656 as text
 

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

format +44785656656 as text
 

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

format +44785656656 as text
 

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