SOLVED
Home

Hebrew formula output

Highlighted
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
Solution

Re: Hebrew formula output

Hi Gittel,

 

Check your local if it's one of English

Locale.JPG

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.