Thanks for your response.
Unfortunately, any mathematical operation gives the resultant value - does
not keep the formula used - I need to have the formula in the cells for later
updates (individually).
For now, I have solved this problem by asking Excel to "ignore the error" -
using the pop-up icon next to the cell.
Still would like to know why this error occurs and why it cannot be solved
by conventional ways.
SM

"Otto Moehrbach" wrote:

The usual way is to perform a mathematical operation on the contents of the
cell. Select an out-of-the-way cell and enter a 1 into that cell. With
that cell selected, do Edit - Copy. Now select the cells with the problem.
Do Edit - PasteSpecial - Multiply. That should force a text number to a
number. HTH Otto
"SM" wrote in message
...
In a column (Excel2007) that is correctly formatted as numeric, one cell
has
=INT(15/0.85+0.5) and has correct format as numeric, another cell has
=INT(75/0.85+0.5) and is formatted as text - both cells show actual values
(not formula). All the cells(over 1000) in this column have similar
content,
and all except TWO have correct numeric format.
I have tried, without success, various ways to change the 2 text cells to
numeric .
I am baffled by this (why these 2 cells are different and why I cannot
change their format).
Any comments/suggestions ?
SM