This sometimes works:
Click on an empty cell and use Copy; select all the cells with the problem;
and use Edit | Paste Special with Add specified. The arithmetic operation
often coerces text to number.
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"prozewski" wrote in message
...
I have a worksheet that has 57 columns which have numeric values but they
are
being recognized as text instead of numeric values. I know that I can do
TextToColumns on each column to get the values to be recognized as
numeric,
but that takes too long. Is there a way to either put the TextToColumns in
a
For/Next loop or is there some easier way to have all values on the sheet
that are numeric recognized as numeric?