display formula instead of its values in some cells

A

ah 3

Hello all,

I encountered problem for some excel files when typing a formula but
displayed a formula instead of its calculated values, e.g.

when I entered "=100 + 100", what I exepected is to display as "200", but it
was displayed as "=100 + 100" instead.

Please kindly help, many thanks!
 
R

Ron Coderre

It seems like that cell is formatted as Text....
Try this:
Format>Cells>Number tab
Category: Number
Click [OK]

Select the cell, press [F2] then press [Enter]

Does that help?

***********
Regards,
Ron

XL2002, WinXP-Pro
 
A

Aladin Akyurek

ah said:
Hello all,

I encountered problem for some excel files when typing a formula but
displayed a formula instead of its calculated values, e.g.

when I entered "=100 + 100", what I exepected is to display as "200", but it
was displayed as "=100 + 100" instead.

Please kindly help, many thanks!
Click to expand...

Remove the double quotes around the formula. Thus like this:

=100 + 100
 
A

ah 3

thanks but can't make test now coz files are in my office, will try and let
you know.


Ron Coderre said:
It seems like that cell is formatted as Text....
Try this:
Format>Cells>Number tab
Category: Number
Click [OK]

Select the cell, press [F2] then press [Enter]

Does that help?

***********
Regards,
Ron

XL2002, WinXP-Pro


ah 3 said:
Hello all,

I encountered problem for some excel files when typing a formula but
displayed a formula instead of its calculated values, e.g.

when I entered "=100 + 100", what I exepected is to display as "200", but
it
was displayed as "=100 + 100" instead.

Please kindly help, many thanks!
Click to expand...
Click to expand...
 
B

Bob Phillips

Check Tools>Options>View and make sure that Formulas is not checked.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)
 
P

Peo Sjoblom

Maybe the workbook is becoming corrupt?
Anyway you can select all formulas and do edit>replace and replace the equal
sign with the equal sign to trigger a calculation before you do that make
sure all formats are not text since if you format a cell as text you will
see the formula and not the result

--

Regards,

Peo Sjoblom
 
A

ah 3

its tested good, thanks.

Ron Coderre said:
It seems like that cell is formatted as Text....
Try this:
Format>Cells>Number tab
Category: Number
Click [OK]

Select the cell, press [F2] then press [Enter]

Does that help?

***********
Regards,
Ron

XL2002, WinXP-Pro


ah 3 said:
Hello all,

I encountered problem for some excel files when typing a formula but
displayed a formula instead of its calculated values, e.g.

when I entered "=100 + 100", what I exepected is to display as "200", but
it
was displayed as "=100 + 100" instead.

Please kindly help, many thanks!
Click to expand...
Click to expand...
 
P

Peo Sjoblom

So if you had 200 cells that were like that you would go through each of
them? My method will do it in one fell swoop
 
A

ah 3

sorry, I haven't study your solution, will try later.

but for Ron's solution, I can also edit one cell and paste to the rest of
the same row/column of cells.

Thanks.
 
Top