How to change default date formula on Excel worksheet

A

alexanderoux

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
 
G

Gord Dibben

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
 

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

Excel Formula Help! 2
Default Date Format 1
Change default printing options to print only worksheet 4
Change default print settings Excel 2007 6
How do I change the comment default format to include date? 4
Automatically Enter Formula in a Cell After Entering Data in Another Cell 0
How to change excel 2007 default name 1
How to set Excel 2010 as default for open excel files instead of 2 1

Top