View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Sumesh[_2_] Sumesh[_2_] is offline
external usenet poster
 
Posts: 4
Default 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