Month and Year Only

X

Xingu

Is there any way to enter just the month and year without the day?
For instance, if I enter 4/6 (for April 2006) it defaults to April 6,
2004. I would like for it to read it as April 2006.

Thank you.
 
E

ElsiePOA

As far as I know, there is no way to enter only month and year. You ca
however make it look the way you want on the sheet through th
formatting process.

First, fortmat the cells, using custom format, to mmmm yyyy. Then, yo
will either have to enter 4/1/6 or 4/2006. Either way, the actua
entry will be April 1, 2006. It will appear as "April 2006" because o
the formatting
 
Top