Format all to General.

Then copy an empty cell.

Select the range to change and EditPaste SpecialAddOKEsc


Gord Dibben MS Excel MVP

On Thu, 30 Oct 2008 09:27:33 -0700 (PDT), wx4usa wrote:

I have a file that was exported from Quick Books.

One column with numbers will not add because there is a little green
arrow in the upper left of each cell indicating it is formatted as
TEXT. I can select the cell individually and change the format to
general or currency - but I cannot select the entire column and change
it. If I select the entire column, it will only change the first non
numeric cell.