Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Need help with converting CUSTOM format/TEXT format to DATE format | Excel Worksheet Functions | |||
Change Date Format to Specific Text Format When Copying | Excel Discussion (Misc queries) | |||
Change number (in text format) to numeric format | Excel Discussion (Misc queries) | |||
how to format excel format to text format with separator "|" in s. | New Users to Excel | |||
How do i change numbers in text format to number format? | New Users to Excel |