Month and Year Only

  • Thread starter Thread starter Xingu
  • Start date Start date
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.
 
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
 
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

Automatically update month 1
Pivot Table - Finanical information by Period as a month 1
Calculating the number of months 2
months on separate tabs 1
Automatically shift chart data range 4
fiscal year calculation 3
Custom Date Format 3
rolling 3 month tracking 3

Back
Top