Number stored as text

I have number stored as text. It has a small green triangle at the upper
left of the cell. If I click on the cell it has a yellowsign with a ! and if
I click on that a menu and "convert to number"
This works fine one cell at a time.

I need to convert columns the cell format has no effect on the column of
cell I need to change. I did un click the protect on the last tab.

Suggestions?
Sueanne

copy an empty cell.
select your range of offending cells
Edit|paste special|check Add



sueanne wrote:
>
> I have number stored as text. It has a small green triangle at the upper
> left of the cell. If I click on the cell it has a yellowsign with a ! and if
> I click on that a menu and "convert to number"
> This works fine one cell at a time.
>
> I need to convert columns the cell format has no effect on the column of
> cell I need to change. I did un click the protect on the last tab.
>
> Suggestions?
> Sueanne

--

Dave Peterson