Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to change default date formula on Excel worksheet
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to change default date formula on Excel worksheet
Change it Windows CP, Regional & Language Options.
-- Regards Dave Hawley www.ozgrid.com "alexanderoux" wrote in message ... 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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to change default date formula on Excel worksheet
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 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I change the default header date format in Excel 2007? | Excel Worksheet Functions | |||
How do I change date default | Excel Discussion (Misc queries) | |||
Excel - change default 'next worksheet' shortcut key to left hnd s | Setting up and Configuration of Excel | |||
How change Excel default date format to something useful | Excel Discussion (Misc queries) | |||
How do I change the default date format in an Excel Footer | Setting up and Configuration of Excel |