You could always try just formatting the cell as text and then enter the date
as mm/dd/yyyy. Or maybe I am not getting what you are asking.

"Seth" wrote:

Hello,

This is a simple question I think. I have an Excel worksheet that is
displaying dates in the Excel standard date format (five digit number).
However, when I click on a cell, the date is displayed in m/d/yyyy format in
the formula bar. How do I get Excel to display it that way in the
worksheet???

Note that the cells are formatted as date, with mm/dd/yy selected.

Thanks,
Seth