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.

Related Conversations
Cost estimator for small scale catering
Louisa Dira in Excel on
12 Replies
How to add the dates using the time criteria ?
Aditya Jadhav in Excel on
7 Replies
This calculation format driving me nuts
jjdrake in Excel on
6 Replies
Having an Issue with Excel hour/time formatting
Mike Button in Excel on
13 Replies
How to convert date format from imported data?
Reuben Helder in Excel on
9 Replies