Default Date Format in Excel

R

RealGomer

Oh, for the days of Quattro Pro.
When I enter a date into Excel into a blank cell as 3/4, Excel insists on
displaying it as 4-Mar and not 3-4-2009. The numeric format is set as the
default under Control Panel - Regional & Language Options - Short Date /
English (United States). All of the cells in the column prior to the blank
cell are also formatted as numeric date.
What to do?
 
G

Gary''s Student

Sadly, Excel is just following your lead. Because you entered only the mm/dd
Excel picked a format with only month and day.

Type 3/4/2009 and Excel will follow that as well.
 
B

Bernard Liengme

This is not standard behaviour. In Excel 2003 (on two PCs) typing 3/4 gives
me 03-Apr (I'm Canadian but 4/3 give 04-Mar). The same happens in Excel
2007.
Open a new workbook and type it ion a new worksheet. Tell us what happens
In time you will find XL outshines QP (but I still love WP over Word)
best wishes
 

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
How do I set the default numeric format in Excel 2007 (XP)? 1
Why can't I convert Long date format to Short date 1
Change Default Auto-Fill-In month 4
Default number format in Excel 1
Excel not using regional settings 6
Date reverts to numeric format 3
Date format getting muddled 3

Top