Month() function doesn't work to convert January to 1

[dngandbored]

Hi there, I tried to use the month() function to convert month (January, February etc) to numeric format in Excel. It doesn't work. I don't know what went wrong. Please see my screenshot below
I typed "March" in C4 and try to convert to "3" by using month( ) but I couldn't please help!!

 

[dngandbored]

With your Windows regional date settings set to English and your Excel date settings set to English, what do you see when you download the file in the link below?

Boxtest.xlsx | Powered by Box

app.box.com

Yes This worked!! I think it is the region & display language issue

 

[dngandbored]

.. or a bit shorter

21 11 14.xlsm
	C	D
4	March	3
Month

Cell Formulas
Range	Formula
D4	D4	=SEARCH(LEFT(C4,3),"..JanFebMarAprMayJunJulAugSepOctNovDec")/3

I'll take note on this just in case my computer went weird again thank you!!

 

[GWteB]

I changed my language setting to English and this still doesn't work... I have no idea now

Regional settings, language settings and display settings aren't the same.

 

[Alex Blakenburg]

Scratch that it sounds like you got something that worked.

 

[MARK858]

Yes This worked!! I think it is the region & display language issue

You're welcome