Forum Discussion

Gittel Marcus's avatar
Gittel Marcus
Copper Contributor
Feb 08, 2018
Solved

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.

Formulas & Functions
Need Help
  • SergeiBaklan's avatar
    SergeiBaklan
    Feb 08, 2018

    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.

2 Replies

  • SergeiBaklan's avatar
    SergeiBaklan
    Diamond Contributor
    Feb 08, 2018

    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.

Resources