Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Default date format (with shortcut keys)
(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" |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Default date format (with shortcut keys)
In Windows CP for Regional Settings-Short Date Format.
-- Regards Dave Hawley www.ozgrid.com "Michael_R" wrote in message ... (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" |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Default date format (with shortcut keys)
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" wrote in message ... (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" |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Shortcut Keys | Excel Discussion (Misc queries) | |||
Shortcut Key Date Format | Excel Worksheet Functions | |||
Shortcut Keys ? | Excel Discussion (Misc queries) | |||
shortcut keys | Excel Discussion (Misc queries) | |||
Shortcut keys for the disables | Excel Discussion (Misc queries) |