Excel 2000 - format date

V

vtz

Hello I am new and exhausted from trying to find an answer to m
problem.

I enter a date into a cell (ex. 020206 which should auto format t
02/02/2006) but when I hit enter I get a weird date that comes u
1/23/7436.
This happens with any date I enter. I tried to custom format the cel
##/##/## but that doesn't work, and I tried "text to columns" but ha
no success.

Any help with detailed solutions would be appreciated.

thank
 
D

Dave Peterson

Excel doesn't have an autoformat to convert your number into a date.

You have to type it in as a date (including slashes), then the format will
display the date the way you like.

But if want a macro to do the work for you, you could use Chip Pearson's:
http://cpearson.com/excel/DateTimeEntry.htm

If you're new to macros, you may want to read David McRitchie's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm

If you want to read more about these kinds of events:

Chip Pearson's site:
http://www.cpearson.com/excel/events.htm

David McRitchie's site:
http://www.mvps.org/dmcritchie/excel/event.htm
 
S

Stephen

vtz said:
Hello I am new and exhausted from trying to find an answer to my
problem.

I enter a date into a cell (ex. 020206 which should auto format to
02/02/2006) but when I hit enter I get a weird date that comes up
1/23/7436.
This happens with any date I enter. I tried to custom format the cell
##/##/## but that doesn't work, and I tried "text to columns" but had
no success.

Any help with detailed solutions would be appreciated.

thanks

vtz
Click to expand...

Excel can only interpret an entry as a date if you enter it in a date
format, including the "/" or "-" or "." separators. Otherwise it's just a
number.
 
Top