Feb 08 2018
01:22 AM
- last edited on
Jul 25 2018
10:59 AM
by
TechCommunityAP
Feb 08 2018
01:22 AM
- last edited on
Jul 25 2018
10:59 AM
by
TechCommunityAP
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.
Feb 08 2018 02:01 AM
SolutionHi 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.
Feb 08 2018 02:01 AM
SolutionHi 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.