Scott,

Sounds like your cells were formatted as Text prior to entering the
function. When that is the case, the function will still appear in the
cell rather than it's result even if you change the format to General.
Try going to Edit, Clear, All. This will remove everything from the
cell you selected. Now type in the formula again.

Does that help?

Steve


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