It sounds like the cell may be formatted as Text

In xl2003 menus:
Select the cell(s)
Format|Cells|Number tab
choose General or number (or anything but Text)
Then select the cell, hit F2 (edit key), and hit enter (done editing)

Or you could be looking at formulas--instead of the results:
Tools|options|view tab|uncheck Formulas
(ctrl-` (ctrl-backquote, the key to the left of the 1/! on my USA keyboard)
is the shortcut key

tazatha wrote:

an excel spreadsheet created by fox pro 9.0 will not calculate the formulas.
They appear as the formula such at =H2*(100+O2)/100
clicking on the cell will not allow it to recalculate. rekeying the formula
some where else in the spread sheet will not calculate. if i copy the lines
from the spreadsheet and put them in a blank spread sheet it will not
calculate. if i retype the formula in another cell farther down the new
spreadsheet and hit enter. the formula will calculate. what is getting set
or changed or what? to prevent formulas from calculating?

--
tazatha

--

Dave Peterson