Only see function not the result

[simontf]

When I use a function I only see the function and not the result.

For example

=now() gives =now(

 

[Chisel]

have you formatted the column to number or whatever you want it t
show.

make sure nothing such as " are at the begining of the functio

 

[simontf]

Thanks for the quick reply

No I didn't do anything like that. If I copy the cells to another
sheet the functions will work.

Regards Simo

 

[Chisel]

I had the same problem and then formatted the cells to nuumber o
currency etc.

Maybe cut and paste the function to somewhere else where is works
format the cells to be used and paste it back in

 

[RagDyeR]

If the cell that contains the formula was formatted as text, you'll see only
the text of the formula, as you are describing.

Simply changing the format to "General" *will not* work.
After changing the cell format, you have to edit the cell in order to have
it revert back to a calculating formula.

Try this:
Click in the "bad" cell, then
<Ctrl> <Shift> <~>, then
<F2> <Enter>.

If that works, you know that the cell format was "Text".

Some other possibilities might be a "space" in front of the equal sign,
Or, the entire sheet could have been set to display formulas.
You can toggle this setting off and on by,
<Ctrl> <~>.
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================



Thanks for the quick reply

No I didn't do anything like that. If I copy the cells to another
sheet the functions will work.

Regards Simon

 

[jee22]

Is it possible that you have mistyped i.e. '=now() would see the expression
as text it should be =now() (no apostrophe)

 

[simontf]

I tried already all the solutions you all said. But this problems mean
for all the cells in that sheet. I can copy the cell to another shee
and it will work when I copy back the cell it will not work.

I think it is something with a property of the sheet. But I do not kno
how I can change it.

Regards Simo

 

[jee22]

Got it I think ........ Tools>options under Windows Options uncheck Formulae

 

[RagDyer]

That does the same thing as
<Ctrl> <~>
that I mentioned above!
--


Regards,

RD

 

[jee22]

Hey RD
I tried you key solution but it did not work ..... any suggestions?

Best

J

That does the same thing as
<Ctrl> <~>
that I mentioned above!
--


Regards,

RD