Default date format

G

Guest

Hi,

how can I change the default date format for all new spreadsheets? right
now, if I don't designate cells a specific format (i.e. general, date,
text...) and I put in a date, it comes out as 17-AUG. I would like it to
display as 08/17 "right out of the box", so to speak.

Thanks.

m-
: )
 
G

Guest

Hi,

Perhaps your system date format will be dd-mmm. To change this go to
Control Panel – Regional and Language Options – Regional Options – Customize
– Date – Short Date Format and select MM-dd-yyy.

See if it works.

Jaleel
 
G

Guest

Thanks for the suggestion, but it did not work. I will post another question
in a different way.

Thanks.
m-
 

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

default date format 1
Date Format 1
How to change default date formula on Excel worksheet 2
Date Default 2
Cell Format 1
Date Calculation & Conditional Formatting 3
Custom footer date format 2
Subtracting Dates 10

Top