If you don't put in the "/" then you need to enter the date number
use 39792

swilkins wrote:

I have formatted a cell for a date format and I've selected it to show
12/10/08 but when I type today's date as 121008 it shows 4/22/31! I've tried
this several times, any suggestions to fix?
Thanks!