<div>
You can change cell format by select a cells or &nbsp;drag many cells and right-click it &nbsp;and click &quot;format cell&quot; from which &nbsp;there is &nbsp;a lot option you can choose for any different &nbsp;number, date ,format,etc ..<br />
If it is not completely to meet your need, you need to do it on VBA<br />
<br />
Duncan
</div>


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

<div>
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.<br />
<br />
John
</div>


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

<div>
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 !
</div>


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 !

<div>
<div class="content wysiwyg-content">
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<br />
Main Phone<br />
<br />
0017 325 486 100<br />
0060 326 879 020<br />
+1300 762 762 <br />
1283563357 &nbsp;&lt;------------------------ this shows as a number want this as text<br />
001 843 412 3743<br />
9.66533E+11 &nbsp; &lt;------------------- this shows as a float &nbsp;want this as text &nbsp;(966532709562 which shows in the formula bar)<br />
1253675695 &lt;------------------------ this shows as a number
</div>
</div>


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

Convert numbers to text in excel 2012

A spreadsheet is an interactive computer application program for organization, analysis and storage of data in tabular form. Spreadsheets developed as computerized simulations of paper accounting worksheets. The program operates on data represented as cells of an array, organized in rows and columns. Each cell of the array may contain either numeric or text data, or the results of formulas that automatically calculate and display a value based on the contents of other cells.

Spreadsheets

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.