Prev: copy if
Next: send color filled shape behind text
From: alexanderoux on 17 Apr 2010 19:03
Excel 2007
Want to change the default formula for date on worksheet.
Currently any date input auto displays as "17-Apr" for example.
I know how to format to display 4/17/2010, but want this as default when I
open the worksheet.

In excel 2003 it was easy set up in "Options" in 2007, I can't seem to
figure how to set this default.
Advises please

From: ozgrid.com on 17 Apr 2010 21:25
Change it Windows CP, Regional & Language Options.


--
Regards
Dave Hawley
www.ozgrid.com
"alexanderoux" <alexanderoux(a)discussions.microsoft.com> wrote in message
news:6E394AB6-C944-4B21-85AF-9BE36DCFBE1D(a)microsoft.com...
> Excel 2007
> Want to change the default formula for date on worksheet.
> Currently any date input auto displays as "17-Apr" for example.
> I know how to format to display 4/17/2010, but want this as default when
> I
> open the worksheet.
>
> In excel 2003 it was easy set up in "Options" in 2007, I can't seem to
> figure how to set this default.
> Advises please
>

From: Gord Dibben on 18 Apr 2010 12:26
How are you entering the dates?

If just m/d you will always get 17-Apr no way to change that.

If m/d/yyyy you will get 4/17/2010 if your Windows Regional Settings for
short date are such.

You misremember about Excel 2003.

There is no default date setting in "Options"


Gord Dibben MS Excel MVP

On Sat, 17 Apr 2010 16:03:01 -0700, alexanderoux
<alexanderoux(a)discussions.microsoft.com> wrote:

>Excel 2007
>Want to change the default formula for date on worksheet.
>Currently any date input auto displays as "17-Apr" for example.
>I know how to format to display 4/17/2010, but want this as default when I
>open the worksheet.
>
>In excel 2003 it was easy set up in "Options" in 2007, I can't seem to
>figure how to set this default.
>Advises please

 | 
Pages: 1
Prev: copy if
Next: send color filled shape behind text