Wrong date format on hyperlinks

TomG! · 05/22/18

Hello all,

I have searched this topic but can't find anything. I'm using UK date formats in my companies sheets and our account is set-up in UK format, however when I link a date from the source sheet into the new sheet the date is displayed in US date format.

Is this a glitch or are we doing something wrong?

Tom

Mike Wilday · 05/22/18

Perhaps your personal settings are set to US? Each user has their own personal settings. User Menu > Personal Settings > Settings... are those settings set accurately? Both the timezone and Regional Preferences? If so, I would recommend contacting support.

egdk · 01/11/19

I have the same problem, only one user, one format, and still this is chaged to US format.. why?

Mike Wilday · 01/11/19

That is a strange event. I would contact support and let them know about the issue. Please reference this thread, and come back and post your discoveries here.

Chris Warren · 03/30/21

This is an old thread but was this ever resolved ? I am having the same problem :(

Richard Golstein · 04/01/21

I am hitting the same issue, i am trying to use contol center and this creates a cell link, however its using US format on the destination sheet vs GMT which is on the source sheet. This is rather frustrating. I think this is a bug that still exists. I'll be logging a ticket for this.

Chris Kaliveas · 04/26/21

Hi,

I encountered this issue too. The cause of my instance is the target link cell was not in Date format and was Text. Even if I changed the format to Date, the value would retain US format. I added a new column next to the bad column field and moved the links into it and whala, it worked (be carefull...500 row limit on moving). Then I moved the links back to my original column and worked. So, be sure to format the destination column correctly before linking.

fyi @Chris Warren

Wrong date format on hyperlinks

Comments

Categories