Prev: .xls .doc files have become corrupted after BSOD!!! how recover?
Next: Pivot Table - replace numbers with a text
From: Michael_R on 6 Apr 2010 05:30
(I am working with XP and Off2007)

<ctrl #> (UK keyboard) applies a date format.

Where do I define which date format this short-cut applies?

What I have found so far:
* <ctrl ;> inserts today's date. in my case that is displayed as
"06/04/2010" - which matches the definition of Control panel, regional
options (English UK), short date.
* <ctrl #> changes the format to "06-Apr-10". I would like this to use
template dd/mm/yyyy - as defined by the regional options. btw the long date
format in regional options is "06 April 2010"
From: ozgrid.com on 6 Apr 2010 05:34
In Windows CP for Regional Settings-Short Date Format.


--
Regards
Dave Hawley
www.ozgrid.com
"Michael_R" <MichaelR(a)discussions.microsoft.com> wrote in message
news:4283FE38-F51F-49DF-9212-CADF7AAE7910(a)microsoft.com...
> (I am working with XP and Off2007)
>
> <ctrl #> (UK keyboard) applies a date format.
>
> Where do I define which date format this short-cut applies?
>
> What I have found so far:
> * <ctrl ;> inserts today's date. in my case that is displayed as
> "06/04/2010" - which matches the definition of Control panel, regional
> options (English UK), short date.
> * <ctrl #> changes the format to "06-Apr-10". I would like this to use
> template dd/mm/yyyy - as defined by the regional options. btw the long
> date
> format in regional options is "06 April 2010"

From: Michael_R on 6 Apr 2010 05:47
Dave,

Thanks for picking this up so quickly.

As I wrote before the CP date format (short date) is dd/mm/yyyy (not
dd-mmm-yy). So I guess there must be another setting somewhere else.
I want the format returned by <ctrl #> to me dd/mm/yyyy

Cheers, Michael

"ozgrid.com" wrote:

> In Windows CP for Regional Settings-Short Date Format.
>
>
> --
> Regards
> Dave Hawley
> www.ozgrid.com
> "Michael_R" <MichaelR(a)discussions.microsoft.com> wrote in message
> news:4283FE38-F51F-49DF-9212-CADF7AAE7910(a)microsoft.com...
> > (I am working with XP and Off2007)
> >
> > <ctrl #> (UK keyboard) applies a date format.
> >
> > Where do I define which date format this short-cut applies?
> >
> > What I have found so far:
> > * <ctrl ;> inserts today's date. in my case that is displayed as
> > "06/04/2010" - which matches the definition of Control panel, regional
> > options (English UK), short date.
> > * <ctrl #> changes the format to "06-Apr-10". I would like this to use
> > template dd/mm/yyyy - as defined by the regional options. btw the long
> > date
> > format in regional options is "06 April 2010"
>
 | 
Pages: 1
Prev: .xls .doc files have become corrupted after BSOD!!! how recover?
Next: Pivot Table - replace numbers with a text