Thanks to all who provided responses. I should have been more specific
on what all I had tried. I had already tried to go to Tools Options
and Formulas was not checked.
I am 100% sure that there is not an apostrophe in front of my formula.
Finally - Thanks Dave! The cell was formatted as text. I tried that
once before, but I never re-entered the formula. I just assumed it
would update automatically.
Problem Solved!!
Thanks All!
DejaVu
--
DejaVu
------------------------------------------------------------------------
DejaVu's Profile:
http://www.excelforum.com/member.php...o&userid=22629
View this thread:
http://www.excelforum.com/showthread...hreadid=400504