Maybe you're looking at formulas.

Try ctrl-` (ctrl-backquote to the left of the 1/! key on my US keyboard)

In xl2003, it's tools|options|view|uncheck formulas.

I don't remember where that option is in xl2007.

Renee805 wrote:

In Excel 2007 I need to have the date read as follows in several columns and
it keeps appearing as a five digit number instead!! Pls help!

Example: I need Jan 1 to read 01/01 in the column

Thanks!

--

Dave Peterson