Forum Discussion
Solved
Date/month/year issue in online onedrive excel
Hi Team, I am getting issue formula between desktop excel & online excel in onedrive (same file uploading in the onedrive). When I am using the formula =text(...,"mmm-yy) in desktop excel it gives ...
- In Excel Online go to File -> Options -> Regional format settings
and see which language you have set.
Set it to the same language as your desktop version.
Thank for responding and just wanted to know where I can get the language setting in desktop version.
I am glad that I could help you.