You may have blanks or ascii-160 characters in the cells along with the
digits. Try running this small macro:

Sub numerify()
Dim r As Range
Count = 0
For Each r In ActiveSheet.UsedRange
If Application.IsText(r.Value) Then
If IsNumeric(r.Value) Then
r.Value = 1# * r.Value
r.NumberFormat = "General"
Count = Count + 1
End If
End If
Next
MsgBox (Count & " cells changed")
End Sub


--
Gary''s Student - gsnu200745


"Emoke" wrote:

Tried that. Still nothing. I also tried to fix each number by hand then reset
the cell formating. (which wouldn't work anyway bc i hace abt 300,000 rows
and 15 columns). Still same issue

"Mike H" wrote:

Maybe,

Select a blank cell and choose Edit|Copy
Select the cells that contain the (text) numbers
Choose Edit|paste special and select Add
Click OK

Mike

"Emoke" wrote:

When I import the files (i recieved via email) into excel, everything is OK,
except Excell doesn't recognise the numbers in the cells as such and as a
result, it doesn't do formulas.. Anyone know the trick to fix the problem?