Format the cell as general
hit F2, then enter to reenter the formula.

MarkGG wrote:

Does anyone have any idea at all? I am fairly good and experienced with
Excel but I haven't seen anything like this and just cannot figure it
out. It is very frustratign because it is working for all of the other
cells on the same worksheet...

Any help would be greatly greatly appreciated

--
MarkGG
------------------------------------------------------------------------
MarkGG's Profile: http://www.excelforum.com/member.php...o&userid=26342
View this thread: http://www.excelforum.com/showthread...hreadid=396091

--

Dave Peterson