format +44785656656 as text

  • Thread starter Thread starter Sumesh
  • Start date Start date
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
 
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
 
Back
Top