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.
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.
and see which language you have set.
Set it to the same language as your desktop version.