Solved Formatting Y Values in Excel to Display Months

Microsoft Excel: mac 2008 (mac)
May 28, 2012 at 01:07:31
Specs: Macintosh
I have a problem in a Gantt Chart that I'm working on. Everything is perfect except for the dates across the y value go from 9/14/11 - 5/6/13. I downloaded this as a template from Microsoft's template gallery but cannot get in contact with the author to find out how they formatted these dates. I need the y value to read April, May, June, July, August, September, October. I just want months, no days but if I had to define days, I guess I would go from the first of each month. I'd rather have the months written out rather than 01/04/12, 01/05/12, 01/06/12, 01/07/12, and so forth. I am in Europe, so the dates would have to be written DD/MM/YY.

I have spent no less than 6 hours trying every way I can think of to change this and scouring the internet for help and I've only come up with solutions to simple y value problems that are unhelpful. The original author had the y values "linked" to a source but I cannot find this source. I've tried unchecking it, playing with the scale under 'formatting axis', and even deleting the column and creating a new one which really messes things up.

Is there anyone out there that I could email my file to in order to have a first hand look to see if they can figure out how to change this and then let me in on the secret in elementary school terms? I cannot explain the trouble I'm having in any other way and I am such a basic user when it comes to Excel, I'd likely have no idea what anyone is talking about if they describe it above a very elementary level. Ironically, Excel for Dummies was no help.

See More: Formatting Y Values in Excel to Display Months

May 28, 2012 at 06:59:47
✔ Best Answer
Try a Custom Format:

Select the cell with your Date,
Right Click your mouse and select Format Cells
In the Category List select Custom, (at the bottom of the list)

On the right side of the window, under the word TYPE,
there is an input box, delete what ever is in the box
and enter: MMMM
Four (4) letter M's
Click OK

Your display should now be the complete month spelled out.
IE: 10/01/2012 will display as OCTOBER

If you want the abbreviation, just use three (3) M's and you get OCT

See how that works.


Report •
Related Solutions

Ask Question