Forum Discussion
Excel 365 online, date formatting problem.
Hello Ian,
is the file, you attached, the original file before you uploaded it to Excel Online? If so, then I noticed that the date format includes a locale set to Armenian, when opening the Format Cells dialogue. Please see the screenshot below. May be (and may be) that's the reason, why it changes to Armenian in Excel Online. I did not test it in Excel Online, as I have different language settings.
Best,
Mourad
The file is as downloaded from Excel online, the formatting to Armenian happens only when working online, I set it to English United Kingdom, then when you check it again after setting it, it reverts to Armenian again.
This only happens when the file is being edited in the browser, it is ok when being edited in Excel, but as I need the function for an online sheet so that multiple users can work simultaneously, its not much good. Back to Google sheets I think.
- cmhabcMar 22, 2019Copper Contributor
Ian Williams did you manage to sort this out. We have the same issue. We have an excel file with travel dates in it and for online viewing it always reverts back to armenian and if I change it still reverts back. Its really annoying all 3 users. We are having to set up the cells at text fields. All three users (including the file owner) have changed our regional settings the english uk.
IT department are also confused, and nobody (it seems) has a solution.
One drive is just not that easy at the minute.
Ian Williams wrote:The file is as downloaded from Excel online, the formatting to Armenian happens only when working online, I set it to English United Kingdom, then when you check it again after setting it, it reverts to Armenian again.
This only happens when the file is being edited in the browser, it is ok when being edited in Excel, but as I need the function for an online sheet so that multiple users can work simultaneously, its not much good. Back to Google sheets I think.- Malcolm_OgdenApr 06, 2019Copper Contributor
I have the same problem. My regional settings (One Drive, PC) are English UK. The format of the cell is English UK but I have to input the dates in American format for them to display as UK format and to behave like an English date when sorting, etc. I only have the problem when I browse online. If I use proper Excel, it's how I want it to be. If I create a new spreadsheet in Excel Online, date cells work how I expect them to, but with people sharing the sheet it's difficult to recreate it in Excel Online from scratch. If I just create a new column in the existing spreadsheet, it behaves like the existing column. This is very frustrating.
- MagedMousaApr 18, 2019Copper Contributor
I have also an issue with Excel Online, which is not found in desktop
any of the following functions return "#VALUE!"
=MONTH(E$72&1) <to convert month name to number>
=DATEVALUE(TODAY())
region settings in both online and desktop sets to "English (United States)"
- SergeiBaklanMar 22, 2019Diamond Contributor
cmhabc , did you changed OneDrive regional settings (not users ones)?
- AnonymousFeb 11, 2017
Hello,
Ok, in this case I can unfortunately not help. May be someone from MS can say more.
Best,
Mourad