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