what do i do to return and have it work? when i hit enter on the vb editor
then go back to spread sheet. still the same. if i close the editor and
return same ugly formula. thnx for the help.
--
tazatha


"Rick Rothstein" wrote:

You can convert all the cells to real formula very quickly using VB. First,
select all cells with the problem, change the Cell Format to General and,
with the selection still active, do the following... right click the tab at
the bottom of the worksheet, select View Code from the popup menu that
appears to get into the VB editor, then copy/paste the following into the
Immediate window (press Ctrl+G if it is not displayed by default)...

Selection.Formula = Selection.Value

then, with you text cursor in the above line, hit the Enter key. Now, when
you go back to the worksheet, all the selected cells should now be active
formulas.

--
Rick (MVP - Excel)


"tazatha" wrote in message
...
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