format +44785656656 as text

S

Sumesh

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
 
S

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
 
Top