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 t...
  • SergeiBaklan's avatar
    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