Always format month in english (not using the excel locale)

[imla]

How to always format cell date to output only month in english

ex:

17/05/2013 -> "May" and not (Mai) in french I use Format Cells... ->Custom-> mmm


Thanks in advince.

 

[Faseeh]

Hi imla,


Can't understand what is excel locale, do you want to change language by method other then changing language in custom format menu?


Regards,

 

[NARAYANK991]

Hi ,


If you select Format -> Custom , and enter :


[$-426]mmm


you will get Mai ; changing the format to :


[$-409]mmm


will display May.


Narayan

 

[Debraj]

@ Imla,


For more detail of NARAYAN's post, You can visit below URL..


http://office.microsoft.com/en-in/excel-help/creating-international-number-formats-HA001034635.aspx


and from my side..

I don't have NON-ENGLISH version for EXCEL.. so fully untested and blind shot.. requesting to confirm if below UDF works for you..


paste the below code in Excel > VBA (Alt + F11) > NewModule

[pre]

Function TestMonth(mnt As Range)
TestMonth = Application.GetCustomListContents(4)(Month(mnt))
End Function[/pre]
if In A1 = 17/5/2013

then in B1 write formula as =TESTMONTH(A1)

Regards,

Deb

 

[imla]

Thanks you all, My stupid solution was to use choose and manualy enter the month name but the [$-409]mmm is exctly what I want; now the month name is always in english.

Thanks again.

 

[SirJB7]

@Debraj Roy

Hi!

Tested in a non-english Excel 2010 version and it works.

Regards!

PS: But not for 17/05/2013, just tested for 01/01/2013, it's easier to input, just 3 chars, 1/1... I hope you'll understand.

 

[Debraj]

@ SirJB7!


Thanks man..

Once I have read somewhere.. that 1st 4 Customs list are same in every version..


Regards,

Deb

 

[SirJB7]

@Debraj Roy

Hi!

I don't know as I've never used them before.

Regards!