format cells, Number tab, Customer, enter mm/d/yy




esiglin wrote:
In Excel 07, I have entered a date in a cell as a date format, 9/1/08.
The Number format shows 'Date'. However, the cell displays 39692.
After reviewing other posts, I have tried a few solutions.
1) Changing the cell format to other options, then back to date.
2) Text-to-Columns, MDY.
These did not work. The cell still displays as 39692.
How do I change the display when the format already says date?

--
Matt Lynn

Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...tions/200809/1