Month Capitalized

[Wenceslau]

Dear Friends,

I am new user to this Forum.
I wanted to convert data format using custom format Excel

Ex.: 2014/01/24 convert to -> January

I need the first letter of the month be capitalized, using only custom formatting, its possible?

Sorry if English is bad, I'm from Brazil =)

Wenceslau

 

[Somendra Misra]

Hi Wenceslau,

Try putting mmmm in Custom Format.

Regards,

 

[Wenceslau]

Tanks Somendra Misra,

But mmmm using the month appears with all text in tiny (january), I need that the first letter is capitalized(January)

 

[Somendra Misra]

Well when I am doing it in Excel 2010 it converts it with Capital J.

Regards,