Excel 2000 - format date

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

vtz - 06 Jan 2006 15:44 GMT

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

Reply to this Message

Dave Peterson - 06 Jan 2006 16:16 GMT

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

> Hello I am new and exhausted from trying to find an answer to my
> problem.
[quoted text clipped - 15 lines]
> vtz's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=30188
> View this thread: http://www.excelforum.com/showthread.php?threadid=498721

Signature

Dave Peterson

Reply to this Message

Stephen - 06 Jan 2006 16:21 GMT

> Hello I am new and exhausted from trying to find an answer to my
> problem.
[quoted text clipped - 11 lines]
>
> vtz

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.

Reply to this Message