Format the Default Date

Hello group,

Ctrl ; inserts the current date into a cell
It is always formatted as the first choice
for dates viz. *14-03-01

Can I change the default format to 14-Mar-01 whenever
I use Ctrl ;

Thanks,

Michael Singmin

I suspect it uses the short date format. This can be redefined for windows
in the regional settings in the control panel.

--
Regards,
Tom Ogilvy

"Michael Singmin" <msing@mweb.co.za> wrote in message
news:5mu181hlm96ukfh331v8gngiu6eehvk6e3@4ax.com...
> Hello group,
>
> Ctrl ; inserts the current date into a cell
> It is always formatted as the first choice
> for dates viz. *14-03-01
>
> Can I change the default format to 14-Mar-01 whenever
> I use Ctrl ;
>
> Thanks,
>
> Michael Singmin
>

Tom/Michael

I can't get the short date format to return 14-Mar-05 in Excel by changing
regional options in WindowsXP SP2.

So, I assigned this macro to CTRL + d

Sub NOWDATE()
With ActiveCell
.Value = Format(Date, "dd-mmm-yy")
.Columns.AutoFit
End With
End Sub


Gord Dibben Excel MVP

On Tue, 10 May 2005 14:49:28 -0400, "Tom Ogilvy" <twogilvy@msn.com> wrote:

>I suspect it uses the short date format. This can be redefined for windows
>in the regional settings in the control panel.
>
>--
>Regards,
>Tom Ogilvy
>
>"Michael Singmin" <msing@mweb.co.za> wrote in message
>news:5mu181hlm96ukfh331v8gngiu6eehvk6e3@4ax.com...
>> Hello group,
>>
>> Ctrl ; inserts the current date into a cell
>> It is always formatted as the first choice
>> for dates viz. *14-03-01
>>
>> Can I change the default format to 14-Mar-01 whenever
>> I use Ctrl ;
>>
>> Thanks,
>>
>> Michael Singmin

After changing it, I had to close excel and reopen it, but it did change how
thinks worked.

From the immediate window:

? ActiveCell.Value
38482
? Format(activecell,"Short Date")
10-May-05

However, it didn't do what the OP wanted. When I did the shortcut key
combination, it entered it dd-mm-yy

So I don't think there is a way to change the default unless you want to
change the Normal style for number to be d-mmm-yy which did work, but then
every number was interpreted as a date.

--
Regards,
Tom Ogilvy




"Gord Dibben" <gorddibbATshawDOTca> wrote in message
news:5uc281tp8esfe1tpmcm9e4ms89bl3vfkfu@4ax.com...
> Tom/Michael
>
> I can't get the short date format to return 14-Mar-05 in Excel by changing
> regional options in WindowsXP SP2.
>
> So, I assigned this macro to CTRL + d
>
> Sub NOWDATE()
> With ActiveCell
> .Value = Format(Date, "dd-mmm-yy")
> .Columns.AutoFit
> End With
> End Sub
>
>
> Gord Dibben Excel MVP
>
> On Tue, 10 May 2005 14:49:28 -0400, "Tom Ogilvy" <twogilvy@msn.com> wrote:
>
> >I suspect it uses the short date format. This can be redefined for
windows
> >in the regional settings in the control panel.
> >
> >--
> >Regards,
> >Tom Ogilvy
> >
> >"Michael Singmin" <msing@mweb.co.za> wrote in message
> >news:5mu181hlm96ukfh331v8gngiu6eehvk6e3@4ax.com...
> >> Hello group,
> >>
> >> Ctrl ; inserts the current date into a cell
> >> It is always formatted as the first choice
> >> for dates viz. *14-03-01
> >>
> >> Can I change the default format to 14-Mar-01 whenever
> >> I use Ctrl ;
> >>
> >> Thanks,
> >>
> >> Michael Singmin
>

All that said,
I assumed preformatting the cells where you will do this is not possible.

--
Regards,
Tom Ogilvy

"Tom Ogilvy" <twogilvy@msn.com> wrote in message
news:e3Qhb3bVFHA.2700@TK2MSFTNGP12.phx.gbl...
> After changing it, I had to close excel and reopen it, but it did change
how
> thinks worked.
>
> From the immediate window:
>
> ? ActiveCell.Value
> 38482
> ? Format(activecell,"Short Date")
> 10-May-05
>
> However, it didn't do what the OP wanted. When I did the shortcut key
> combination, it entered it dd-mm-yy
>
> So I don't think there is a way to change the default unless you want to
> change the Normal style for number to be d-mmm-yy which did work, but then
> every number was interpreted as a date.
>
> --
> Regards,
> Tom Ogilvy
>
>
>
>
> "Gord Dibben" <gorddibbATshawDOTca> wrote in message
> news:5uc281tp8esfe1tpmcm9e4ms89bl3vfkfu@4ax.com...
> > Tom/Michael
> >
> > I can't get the short date format to return 14-Mar-05 in Excel by
changing
> > regional options in WindowsXP SP2.
> >
> > So, I assigned this macro to CTRL + d
> >
> > Sub NOWDATE()
> > With ActiveCell
> > .Value = Format(Date, "dd-mmm-yy")
> > .Columns.AutoFit
> > End With
> > End Sub
> >
> >
> > Gord Dibben Excel MVP
> >
> > On Tue, 10 May 2005 14:49:28 -0400, "Tom Ogilvy" <twogilvy@msn.com>
wrote:
> >
> > >I suspect it uses the short date format. This can be redefined for
> windows
> > >in the regional settings in the control panel.
> > >
> > >--
> > >Regards,
> > >Tom Ogilvy
> > >
> > >"Michael Singmin" <msing@mweb.co.za> wrote in message
> > >news:5mu181hlm96ukfh331v8gngiu6eehvk6e3@4ax.com...
> > >> Hello group,
> > >>
> > >> Ctrl ; inserts the current date into a cell
> > >> It is always formatted as the first choice
> > >> for dates viz. *14-03-01
> > >>
> > >> Can I change the default format to 14-Mar-01 whenever
> > >> I use Ctrl ;
> > >>
> > >> Thanks,
> > >>
> > >> Michael Singmin
> >
>
>

Thanks Tom,

I checked Regional Settings and the short date was okay.
I decided to make my own macro for the date setting.

Cheers,

Michael


"Tom Ogilvy" <twogilvy@msn.com> wrote:

>I suspect it uses the short date format. This can be redefined for windows
>in the regional settings in the control panel.