<div>
as you can see, it is a number and not text and I need to sort the column and in its present format it will not sort correctly.
</div>


<div>
BUT the other cells above show TEST and not numeric fields so your sort wouls make no sense. What are trying to sort?<br />

</div>


<div>
Note: text to columns will convert the numbers and leave the text alone.......<br />
<br />
barry
</div>


<div>
wow that worked perfectly. &nbsp;thank you
</div>


<div>
<div class="content wysiwyg-content">
Experts, how can I change the format of the cells to number? &nbsp;It is not as easy as changing the format of the cell to number though. &nbsp;I have to click each cell and choose &quot;convert to number&quot;. &nbsp;I have many cells like this and I need to find a quicker way to convert the cells. <br />
<br />
thank you <a href="https://filedb.experts-exchange.com/incoming/2011/11_w46/520195/untitled.JPG" target="_blank" title="Convert to Number (26 KB)"><img alt="Convert to Number" class="file-block lazyload" style="max-width: 368px;" data-src="https://filedb.experts-exchange.com/incoming/2011/11_w46/520195/untitled.JPG" /></a>
</div>
</div>


untitled.JPG

Experts, how can I change the format of the cells to number?  It is not as easy as changing the format of the cell to number though.  I have to click each cell and choose "convert to number".  I have many cells like this and I need to find a quicker way to convert the cells. 

thank you 

as you can see, it is a number and not text and I need to sort the column and in its present format it will not sort correctly.

BUT the other cells above show TEST and not numeric fields so your sort wouls make no sense. What are trying to sort?


Note: text to columns will convert the numbers and leave the text alone.......

barry

Number stored as text ==&gt; convert to number quickly

Experts, how can I change the format of the cells to number?  It is not as easy as changing the format of the cell to number though.  I have to click each cell and choose &quot;convert to number&quot;.  I have many cells like this and I need to find a quicker way to convert the cells. 

thank you 

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

Number stored as text ==&gt; convert to number quickly

Number stored as text ==> convert to number quickly