Rather than deleting and re-entering the formula, just hit F2 then ENTER key
after formatting to General.


Gord Dibben MS Excel MVP

On Thu, 3 Jan 2008 08:22:03 -0800, Mike Rogers <Mike060349@NoxSpamxAOLDOTcom
wrote:

Rich

Make sure the cell is not formated to text BEFORE you enter your formula.
If the cell is formated to text and the formula is in place delete the
formulaformate as GENERAL re-enter the formula and it should work. There
are also other ways to do the same thing but this works.

Mike Rogers

"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