Cells Formatted as Text

[MichaelQ]

Version: 2008 Operating System: Mac OS X 10.6 (Snow Leopard) Processor: Intel I have a work sheet that contains over 10,000 rows and some columns of numbers contain numbers formatted as text. If I select the column and format as text it does not alter the text cells. I find I have to manually change each cell.
How can I search for a cell formatted as text?
or
How can I format the column to numbers?

 

[CyberTaz]

If the numbers are actually values [not zip codes or something similar]:

Type the number 1 into a cell,
Copy that cell,
Select the column of figures,
Go to Edit> Paste Special & select the Multiply option,
Click OK

That will convert those formatted as Text back to values but will have no
impact on any of those which are already formatted properly.

HTH |:>)
Bob Jones
[MVP] Office:Mac

 

[MichaelQ]

Thank you very much you have solved the problem.

MichaelQ

If the numbers are actually values [not zip codes or something similar]:
>
> Type the number 1 into a cell,
> Copy that cell,
> Select the column of figures,
> Go to Edit> Paste Special & select the Multiply option,
> Click OK
>
> That will convert those formatted as Text back to values but will have no
> impact on any of those which are already formatted properly.
>
> HTH |:>)
> Bob Jones
> [MVP] Office:Mac
>
>
>
> On 2/7/10 3:35 PM, in article (e-mail address removed)2ac0,
> "[email protected]" wrote:
>

> > Version: 2008 Operating System: Mac OS X 10.6 (Snow Leopard) Processor: Intel
> > I have a work sheet that contains over 10,000 rows and some columns of numbers
> > contain numbers formatted as text. If I select the column and format as text
> > it does not alter the text cells. I find I have to manually change each cell.
> > How can I search for a cell formatted as text?
> > or
> > How can I format the column to numbers?

>
>