View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Mike H Mike H is offline
external usenet poster
 
Posts: 11,501
Default Going nuts in Excel 2003

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