default date format

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Kruppy - 24 Nov 2007 02:34 GMT

When a enter a date in Excel 2003 it formats it (by default) as 22-Nov. The
short date regional setting in windows is 11/22/07. When I go to change the
date format the format that is highlighted is Custom dd-mmm. Any idea
where this comes from and how I can change it.

Reply to this Message

Niek Otten - 24 Nov 2007 14:35 GMT

I think that when you include the year (even if it is only 2 digits) it will use Windows' short date format

Signature

Kind regards,

Niek Otten
Microsoft MVP - Excel

| When a enter a date in Excel 2003 it formats it (by default) as 22-Nov. The
| short date regional setting in windows is 11/22/07. When I go to change the
| date format the format that is highlighted is Custom dd-mmm. Any idea
| where this comes from and how I can change it.

Reply to this Message

Dave Peterson - 24 Nov 2007 17:48 GMT

I usually like mm/dd/yyyy and I've given up fighting excel.

If a cell is going to contain a date, I'll do this:
ctrl-;
(to enter today's date--and change the format)
then type the new date.

> When a enter a date in Excel 2003 it formats it (by default) as 22-Nov. The
> short date regional setting in windows is 11/22/07. When I go to change the
> date format the format that is highlighted is Custom dd-mmm. Any idea
> where this comes from and how I can change it.

Signature

Dave Peterson

Reply to this Message

Niek Otten - 24 Nov 2007 18:29 GMT

Nice one, Dave!

Signature

Kind regards,

Niek Otten
Microsoft MVP - Excel

|I usually like mm/dd/yyyy and I've given up fighting excel.
|
[quoted text clipped - 7 lines]
| > date format the format that is highlighted is Custom dd-mmm. Any idea
| > where this comes from and how I can change it.

Reply to this Message

Dave Peterson - 24 Nov 2007 18:46 GMT

Well, lots of times, I enter the date, then hit ctrl-z to undo, then do those
steps. <vbg>

It can be quicker than formatting the cell.

> Nice one, Dave!
> --
[quoted text clipped - 18 lines]
> |
> | Dave Peterson

Signature

Dave Peterson

Reply to this Message

Kruppy - 24 Nov 2007 20:52 GMT

Thanks, It is a good work around. There should be a better way to do it but
this is very quick and easy. Thanks againb

Signature

Kruppy

> I usually like mm/dd/yyyy and I've given up fighting excel.
>
[quoted text clipped - 7 lines]
> > date format the format that is highlighted is Custom dd-mmm. Any idea
> > where this comes from and how I can change it.

Reply to this Message