Gord, formatting is not the problem, I have checked that.

Thanks

Ken

"Gord Dibben" wrote:

If the data is formatted as text................

Format all to General.

Copy an empty cell.

Select the data range and EditPaste SpecialAddOKEsc.


Gord Dibben MS Excel MVP

On Wed, 11 Jul 2007 14:59:34 -0700, "Peo Sjoblom" wrote:

See if the values are text.

Select a cell, format it as general then put this formula there

=ISNUMBER(cell)

and check all cells in question, if they return TRUE it is OK if FALSE then
there is your answer.
Also make sure calculations are set to automatic under
toolsoptionscalculation