Only see function not the result

  • Thread starter Thread starter simontf
  • Start date Start date
S

simontf

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

For example

=now() gives =now(
 
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
 
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
 
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
 
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
 
Is it possible that you have mistyped i.e. '=now() would see the expression
as text it should be =now() (no apostrophe)
 
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
 
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...
 
Back
Top