Hi,

Dates in Excel are numbers and the number 101408 is August 22 2077 so Excel
is doing exactly what your telling it to do. Without resorting to VB I don't
know of any way to make it recognise that number as the date you believe it
is. can't you enter delimeters 10/14/08

Mike

"Mary Put" wrote:

How do I format cells so that when I put in a number it automatically changes
it to a date? I set up the cells using Format-Number-Date-03/14/01. But
when I type in 101408 the cell shows 08/22/77. What am I doing wrong??