Default date format (with shortcut keys)

M

Michael_R

(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"
 
M

Michael_R

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

date format 1
Excel 2007 text import as text not date 3
date format 1
Vba Date$ 1
Default date format 4
Why can't I convert Long date format to Short date 1
Excel is changing date format incorrectly 7
Date format in permanent list 1

Top