### Convert numbers stored as text to numbers in excel 2008

by **rchambers** » Fri, 04 Jun 2010 23:35:42 GMT

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)
Processor: Intel
Trying to sort a spreadsheet using a column that has numbers stored as text. When I sort, the number 1001 is ahead of the number 106. The numbers are all on the left of the cell. How do I convert? <br><br>Thanks <br>
R

### Re: Convert numbers stored as text to numbers in excel 2008

by **lrivers** » Sun, 06 Jun 2010 03:42:19 GMT

> Trying to sort a spreadsheet using a column that has numbers stored as text. When I sort, the number 1001 is ahead of the number 106. The numbers are all on the left of the cell. How do I convert? <br>

### Re: Convert numbers stored as text to numbers in excel 2008

by **John_McGhie_[MVP]** » Sun, 06 Jun 2010 08:45:00 GMT

Convert those text cells to numbers:
* Find a temporary cell and enter 1 as the value in that cell
* Copy the temporary cell
* Highlight your numbers cell range
* Use Edit > Paste Special > Multiply to multiply all of those 1000 cells by
1.
Excel will force them all to be numbers when it does that :-)
Cheers
On 4/06/10 12:35 AM, in article XXXX@XXXXX.COM ,
--
The email below is my business email -- Please do not email me about forum
matters unless I ask you to; or unless you intend to pay!
John McGhie, Microsoft MVP (Word, Mac Word), Consultant Technical Writer,
McGhie Information Engineering Pty Ltd
Sydney, Australia. | Ph: +61 (0)4 1209 1410 | mailto: XXXX@XXXXX.COM