Prev: Formula Help
Next: how do i print from excel to envelopes
From: Loris on 29 Mar 2010 11:11
When applying the keyboard shortcut CTRL+SHIFT+# to a number, Excel formats
that number in the 29-Mar-10 format by default. How do I change that default
format for the current and all futire workbooks?
From: "David Biddulph" groups [at] on 29 Mar 2010 15:45
Try changing your Windows Regional Options (in Control Panel, not in Excel).
--
David Biddulph


"Loris" <Loris(a)discussions.microsoft.com> wrote in message
news:D884899B-91A3-49ED-93F0-7D5508D64C2A(a)microsoft.com...
> When applying the keyboard shortcut CTRL+SHIFT+# to a number, Excel
> formats
> that number in the 29-Mar-10 format by default. How do I change that
> default
> format for the current and all futire workbooks?


From: Gord Dibben on 29 Mar 2010 17:23
David

I have found using that particular farmat date shortcut Excel ignores the
Regional Settings for shortdate.

I have not found a method of changing that default.

With my Regional settings of mm/dd/yyyy TODAY() and CTRL + ; both return
mm/dd/yyyy

BUT enter 40266 or today's date in a cell

Format to date by CTRL + SHIFT + # always defaults to dd-mmm-yy


Gord Dibben MS Excel MVP

On Mon, 29 Mar 2010 20:45:51 +0100, "David Biddulph" <groups [at]
biddulph.org.uk> wrote:

>Try changing your Windows Regional Options (in Control Panel, not in Excel).

 | 
Pages: 1
Prev: Formula Help
Next: how do i print from excel to envelopes