Tsk! I goofed, Dave -- I unchecked the wrong "Formulas" box ... I looked at
the steps to your suggestion, again, and noticed that I had unchecked Formula
BAR in Show, instead of Formulas in the Windows Options section -- IT
WORKED!!

AWESOME ... THANK YOU!!

"Dave Peterson" wrote:

Maybe you're looking at formulas:

Tools|Options|view tab|uncheck formulas.

GirafeLady wrote:

I inherited an huge Excel spreadsheet and have come across the
strangest issue I've ever seen! I have a columns dedicated to "Date Rec'd"
and "Date Sent" and all cells are formatted to mm/dd/yy. However, when I type
in the date, a totally unrelated number appears (e.g., 4/4/2006 appears as
38811)!! I've unlocked all cells, but that hasn't helped. When I select Text
as opposed to
Date, the 38811 number appears ... all other format options show the 38811!
I also have cells formatted as Currency, 2 decimals, show $ sign and the
formatting is being ignored here, as well.

I'm completely stumped ... can anyone out here offer a solution/suggestion?

Thanks!
~Mary

--

Dave Peterson