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?