Hebrew formula output

Gittel Marcus
New Contributor

Hebrew formula output

Hi.    I have a very simple formula: =TEXT(G3,"mmm. Dd")


and the output is unfortunately 07. פבר


The language settings (under Options/Language) are set to English.  I've tried formating the individual cells to English - no dice.  I have a new operating system, and Microsoft Office Language Preferences are English.


In the Control panel - English is set as the default.  Any advice?  Thanks.

2 Replies

Re: Hebrew formula output

Hi Gittel,


Check your local if it's one of English


or you may specify locale directly in TEXT format like

=TEXT(G3,"[$-409]mmm. dd")

for US one.

Re: Hebrew formula output

Thank you.  That formula is working great.