thanks so much. that is much simpler way to get it to calculate. I can get
this to my users now so they can get the data to calculate quickly. Now the
programmer just has to figure out what he did in fox pro to make the program
set up the excel spread sheet like this since it just started happening on
his last version of the export.
--
tazatha


"Dave Peterson" wrote:

Select the range to fix
Change the range's format to Gneral (or whatever you want)
Edit|replace
what: = (equal sign)
with: =
replace all

Excel will see that each is a formula and reevaluate each formula.

tazatha wrote:

Partially answered the question for my circumstances. I did not have
formulas checked to be shown, even formulas that evaluated to text are not
working. I did not have to change the type - number, text, general, but what
i did have to do was your suggestion to click on cell and hit F2, then enter.
that made the value show up instead of the formula.

The spreadsheet created by the fox pro program previously created the sheet
with values showing automatically. There are too many cells to have to ht f2
and enter on each one.

Any ideas on what i can do to the whole spreadsheet to get it to show values
inistead of formula?

--
tazatha

"Dave Peterson" wrote:

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


--

Dave Peterson