SOLVED

Hebrew formula output

Copper Contributor

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
best response confirmed by Gittel Marcus (Copper Contributor)
Solution

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.

Thank you.  That formula is working great.

1 best response

Accepted Solutions
best response confirmed by Gittel Marcus (Copper Contributor)
Solution

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.

View solution in original post