Mike,
Check the format of the cells that you are entering the formula in
prior to entering. If they are formatted as Text prior to entering the
formula, the result will be that you see the formula. If this is the
case, re-format to General, enter your formulas and then you can
re-format back to Text. If not, check the workbook options.
ToolsOptionsView if the checkbox next to Formulas is selected,
deselect it, click OK and go back and try entering your formulas again.
HTH
Cheers,
Steve
--
SteveG
------------------------------------------------------------------------
SteveG's Profile:
http://www.excelforum.com/member.php...fo&userid=7571
View this thread:
http://www.excelforum.com/showthread...hreadid=496934