SOLVED

Browser vs Desktop display of European dates in the function editing bar

Copper Contributor

The same cell value displays differently in the function editing bar in Desktop vs. Browser.  Why?

 

Col. B is formatted dd/MM/yyyy.  OS region set to English (Ireland).  Tested in Chrome & IE.

 

clipboard_image_1.png

2 Replies

Resolved:  The SharePoint site's regional settings where set to US.  Changing this site's regional setting to English (Ireland) resolved this.

best response confirmed by cymorg1 (Copper Contributor)
Solution

Hi @cymorg1 

 

I believe it's a OneDrive / SharePoint setting

 

If you go to One Drive and click the top right cog, then more Settings,  Regional Settings

 

clipboard_image_0.png

 

And check your Region / Locale

clipboard_image_1.png

 

 

 

1 best response

Accepted Solutions
best response confirmed by cymorg1 (Copper Contributor)
Solution

Hi @cymorg1 

 

I believe it's a OneDrive / SharePoint setting

 

If you go to One Drive and click the top right cog, then more Settings,  Regional Settings

 

clipboard_image_0.png

 

And check your Region / Locale

clipboard_image_1.png

 

 

 

View solution in original post