You can get it to show MM/YY but you still have to input it all.

--
HTH

Bob Phillips

"tamato43" wrote in message
...
Is there a way to format it correctly then? to just show Month year?

"Bob Phillips" wrote:

Yes, date input assumes you will start with the day (month in the US),
and
then assumes a month (day) and if you don't add a year it defaults to
this
year.

--
HTH

Bob Phillips

"tamato43" wrote in message
...
I'm rying to create a Month and Year (MM/YY) field on a spreadsheet to
document expiration date.

I've formatted the cell to show Month/Year (MM/YY, MM-YY, Mon-YY), but
when
I just enter month and year, e.g. 03/06, it defaults to Mar-05.

Am I doing something wrong?