Default Date Format in Excel

  • Thread starter Thread starter RealGomer
  • Start date Start date
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?
 
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.
 
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
Excel not using regional settings 6
Default date format (with shortcut keys) 2
Excel date formats 2
Excel Help with dates 2
Why can't I convert Long date format to Short date 1
How do I set the default numeric format in Excel 2007 (XP)? 1
Dates in Excel 2007 5

Back
Top