Thanks SteveG, but this did not help either. Any other suggestions?

"SteveG" wrote:


Or the cell you are entering the formula in was formatted as text prior
to entering it. Delete the formulas, re-format to General and re-enter
your formulas. Then you can re-format back to text if need be.


Cheers,

Steve


--
SteveG
------------------------------------------------------------------------
SteveG's Profile: http://www.excelforum.com/member.php...fo&userid=7571
View this thread: http://www.excelforum.com/showthread...hreadid=494598