Wrong date format on hyperlinks

TomG!

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

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

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

Mike Wilday

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

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

Richard Golstein

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

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