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 correct output.
While the same excel I am using with online ondrive excel that time the same formula does not give correct output.
Can you help on this how to correct in the one drive online excel.
Desktop excel which gives correct output.
Online ondrive excel which gives incorrect output.
- 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.- 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.
