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

When I insert a worksheet the cell format is accounting 1
Closing PDF file from Excel VBA (Adobe Reader, Adobe Acrobat, Browser) 0
Default Date Format 1
Object Browser in VBA 0
VBA to do a mailmerge from a Specific Excel worksheet 0
Excel Formula Help! 2
Help with an Excel formula please? 7
How do I change the comment default format to include date? 4

Top