formulas not auto calculating and will not calculate
What do you see in the cell (not the Formula Bar)? What is the Cell Format
of the cell containing the formula?
--
Rick (MVP - Excel)
"tazatha" wrote in message
...
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
|