I need a cell (to show Mar-09) it automatically goes to Mar-08

  • Thread starter Thread starter Nat
  • Start date Start date
N

Nat

Trying to format the column, I type in 3/09 wanting it to show Mar-09 and it
automatically goes to Mar-08
 
Hi,

Don is correct, of course. But why? If you check your formula bar after
you type 3/09 you will see that Excel figured you ment 3/9/2008. Excel has
to guess what the 9 means - the month or the year, it goes for month and
assumes the current year. If you typed 3/32 excel would know this could not
be a day of the month so it would assume you wanted the first, 3/1/1932.
 
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

2 dimensional date sort 1
How to write XIRR formula on excel using different Year basis than 365. 5
help with date formula 5
To Calculate the qty b/w two dates 6
days calculations 6
Calculate End Date Using Start Date and No. of Days excluding specific days. 0
Date issue to automate calendar 23
Worksheet Function required 2

Back
Top