Convert numbers to text in excel 2012

I have a CSV which I transfer to exel. I format the column as text but some lines still show as numeric or float - how can I convert these to text as these are telphone numbers
Main Phone

0017 325 486 100
0060 326 879 020
+1300 762 762
1283563357  <------------------------ this shows as a number want this as text
001 843 412 3743
9.66533E+11   <------------------- this shows as a float  want this as text  (966532709562 which shows in the formula bar)
1253675695 <------------------------ this shows as a number
Chris MichalczukConsultantAsked:
Who is Participating?
 
johnb25Connect With a Mentor Commented:
If you select the column/range with the phone numbers, and do Data/Text to Columns from the ribbon.
Select Fixed Width, and then chose Text as the Column Data Format.


John
0
 
duncanb7Commented:
You can change cell format by select a cells or  drag many cells and right-click it  and click "format cell" from which  there is  a lot option you can choose for any different  number, date ,format,etc ..
If it is not completely to meet your need, you need to do it on VBA

Duncan
0
 
johnb25Commented:
Alternatively, you can try to change the file extension to .txt before opening it, and in the Text Import wizard, specify that column as being a Text column.

John
0
 
Chris MichalczukConsultantAuthor Commented:
is there no other way to convert this - I have used the format cell as text type but it ignores these specifics as if it doesnt understand how to convert to text !
0
 
Chris MichalczukConsultantAuthor Commented:
you are a star !
0
All Courses

From novice to tech pro — start learning today.