Date Entry Question

  • Thread starter Thread starter Dustin
  • Start date Start date
D

Dustin

I want to enter JUST the month and year and have Excel
recognize it as such. Unfortunately, Excel decides the
year I am entering is a day of a month and uses the
current year to complete the date. For example, I enter
Feb-03 into a date-formatted cell (Mmm-yy) and Excel shows
Feb-04 as the output. If I click on the cell, the value
is 2/3/2004. Is there anyway around this?
 
Excel will always treat a date as mm/dd/yyyy format (at least in the U.S.).
So if you enter 02/2004, Excel will show 2/1/2004 in the formula bar. The
only thing you can do (I think) is format the cell as mm/yyyy or however you
want it to appear.
 
I think Trevor's response is true if you need to have
Excel recognize the entry as a date. But if you don't
need that, you could also format the cell as text. Then
you can enter whatever you want.
 
You must log in or register to reply here.

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 Vba to change displayed year automatically. 14
Date Difference 4
date entry 20
help on formula 1
Date Formatting 12
date & month 6
Entering date as MM/DD/YY no longer works, why? 1
Change Default Auto-Fill-In month 4

Back
Top