from 07/01/2011 to July 2011

July 14, 2011 at 07:36:27
Specs: Windows XP
I have a quick question for an excel expert.

I have date as 07/01/2011
How do I format it to be July 2011?

Please help

See More: from 07/01/2011 to July 2011

Report •

July 14, 2011 at 11:47:39
You need a Custom Format:

mmmm yyyy

Select your cell
Right Click
Select Format Cells
Select Number Tab
Select Custom - bottom of category list
In the input box titled: Type
Delete what ever is in there, probably the word General and enter the above.


Report •

July 15, 2011 at 02:34:58

thank you very much. It works.
By the way, one friend of mine helped me with this formula "+TEXT(Cell,"MMMM)"
In this way I can keep the day in the data imput cell (07/01/2011) and in another cell have the text (July)

thank you anyway for you help.

Report •

July 15, 2011 at 03:48:02
Just an FYI...

The modern day standard for an Excel formula is to use an equal sign, not a plus sign, when entering a formula.

If you use the plus sign, Excel will add an equal sign anyway, but the plus sign doesn't do anything, except make the formula look strange.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

Report •

Related Solutions

Ask Question