Format date in a cell

  • Thread starter Thread starter Mary Put
  • Start date Start date
M

Mary Put

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??
 
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
 
Back
Top