column format 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. How do I do this? Would be great if I could see a
sample.

Thanks
Sumesh
 
Back
Top