that enables me to see all my formulas or not, but it didn't solve the
problem. There is something messed up in that it won't allow me to change
formats in cells either.
--
Rich D
Armstrong Custom Homes
Redmond


"Mike H" wrote:

Try

CTRL+`

The ` is to the left of the 1 key

Mike

"Rich D" wrote:

Hi guys & gals,

I must have a button pushed or something that I don't know about. I'm
entering =IF($L5="","",$C5). That's exactly what it shows in the cell. It's
as if I have it preceded with a ', but I don't. I set the format to
general,,,still no good. Other cols it won't let me change the format.
These are brand new worksheets so I don't know what the problem is. Is it
the num lock or insert key??

thanks for any help.
--
Rich D
Armstrong Custom Homes
Redmond