Format all to General.

Copy an empty cell.

Select the range of data and EditPaste Special(in place)AddOKEsc.


Gord Dibben MS Excel MVP

On Tue, 20 Mar 2007 12:28:08 -0700, beadedbeauty
wrote:

My co-worker is having issues with a file that was exported to Excel. One
column has text format and contains numbers. He needs to add the numbers but
the column is text formatted. He cannot use FORMAT CELL and select number.
It appears to work but doesn't . The column is still text formatted. What
does he need to do? He can change one cell at a time because it gives him a
little error indicator in the corner of the cell but this is too time
consuming.