Only see function not the result

S

simontf

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

For example

=now() gives =now(
 
C

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
 
S

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
 
C

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
 
R

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
 
J

jee22

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

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
 
J

jee22

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

Best

J

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


Regards,

RD
Click to expand...
 
Top