Using Excel 2003 on WinXP. Have chosen to format the cell as a date (in
mm/dd/yyyy format). When entering only numbers into the cell, the "date"
that displays is in no way the actual date. So, when I enter 72508, the cell
displays 07/07/2098. When I enter 7/25/08, the cell displays 7/25/2008. Is
there a way to make the cell show a date in mm/dd/yyyy format and only enter
numbers and not include the dashes or hash marks when entering the numbers?
I know that it works when entering phone numbers (if you've formatted the
cell to display phone numbers - you enter 5558885555 and get (555) 888-5555.)
Thanks in advance.