Forum Discussion
Gittel Marcus
Feb 08, 2018Copper 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 t...
- 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.
SergeiBaklan
Feb 08, 2018Diamond Contributor
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.
- Gittel MarcusFeb 08, 2018Copper Contributor
Thank you. That formula is working great.