Results 1 to 11 of 11

Entering month/year, instead of month/day/year, and displaying as such

Threaded View

Gunther Maplethorpe Entering month/year, instead... 03-09-2011, 02:23 PM
wonderdunder Re: Entering month/year,... 03-09-2011, 02:34 PM
wonderdunder Re: Entering month/year,... 03-09-2011, 02:39 PM
Gunther Maplethorpe Re: Entering month/year,... 03-09-2011, 02:43 PM
wonderdunder Re: Entering month/year,... 03-09-2011, 02:50 PM
Gunther Maplethorpe Re: Entering month/year,... 03-09-2011, 02:59 PM
ChemistB Re: Entering month/year,... 03-09-2011, 04:22 PM
Gunther Maplethorpe Re: Entering month/year,... 03-09-2011, 04:28 PM
ChemistB Re: Entering month/year,... 03-09-2011, 04:34 PM
Gunther Maplethorpe Re: Entering month/year,... 03-09-2011, 07:45 PM
CILLA Re: Entering month/year,... 07-17-2011, 07:31 PM
  1. 03-09-2011, 02:23 PM #1
    Gunther Maplethorpe is offline
    Forum Contributor
    Join Date
    01-11-2011
    Location
    Frederick, MD, USA
    MS-Off Ver
    Excel 2007
    Posts
    125

    Entering month/year, instead of month/day/year, and displaying as such

    Is there a way to enter, say, "3/11" and have Excel recognize it as "March 2011" instead of assuming that I'm entering March 3rd of the current year? I've tried fiddling with the cell formatting, but to no avail. The best I can come up with is entering "3/(any day)/11" to display as month/year, but I'd like to NOT enter any day at all.

    I realize that entries such as "3/11" are inherently ambiguous...is it March 11th, or March of 2011? But if I have a set of entries that will always be month/year, how can I force them to display as such?

    Also acceptable would be forcing the cell to the last day of that given month (eg forcing "3/11" to display as "March 30th, 2011"), but I'd prefer to just have month/year without having to enter month/day/year.

    EDIT: After realizing that this doesn;t explain things fully, I should state that I want an entry of 3/11 to display as March 2011, and an entry of 3/12 to display as March 2012.
    Last edited by Gunther Maplethorpe; 03-09-2011 at 07:44 PM.
    Reply With QuoteRegister To Reply
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1