cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Announcements
Are you interested in hearing how one of our Community members uses Dropbox for sailing trips? Read all about it here.

View, download, and export

Need support with viewing, downloading, and exporting files and folders from your Dropbox account? Find help from the Dropbox Community.

cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 

Re: Date of file changes from UK to USA version when added to Dropbox

Date of file changes from UK to USA version when added to Dropbox

Lyn14
Explorer | Level 4

I have produced a spreadsheet, but when its put into dropbox the dates changed from UK to USA version.  Is there away to stop this

Thanks inadvance

1 Accepted Solution

Accepted Solutions

Nancy
Dropbox Staff

Thanks for the screenshot, @Lyn14! From your screenshot, it looks like you’re previewing the file on the Dropbox website. 

 

Can you please click on the “Open in” button above the preview, and open your file with Excel for the web instead? Do you still see the dates in the US format then?

 

If yes, do you see any option to switch to the UK format instead?


Nancy
Community Moderator @ Dropbox
dropbox.com/support


Heart Did this post help you? If so, give it a Like below to let us know.
:arrows_counterclockwise: Need help with something else? Ask me a question!
:pushpin: Find Tips & Tricks Discover more ways to use Dropbox here!
:arrows_counterclockwise: Interested in Community Groups? Click here to join!

View solution in original post

24 Replies 24

Mark
Super User II

I find the same often happens 😞 

 

Do check, however, that in Account Settings (https://www.dropbox.com/account/general) your date format is set correctly. 


 


:penguin::penguin: - :penguin: - :penguin: - :penguin:


Heart Did this post help you? If so please mark it for some Kudos below. 


:white_check_mark: Did this post fix your issue/answer your question? If so please press the 'Accept as Solution' button to help others find it.


:arrows_counterclockwise: Did this post not resolve your issue? If so please give us some more information so we can try and help - please remember we cannot see over your shoulder so be as descriptive as possible! 


 

Lyn14
Explorer | Level 4

Thank you for your reply.  I had not realised there was a format date in the dropbox but having checked it was the UK format.

So not sure what to do.

Hannah
Dropbox Staff

Hey @Lyn14, would you mind sending us a screenshot of where you're seeing this?

 

Also, how are you adding the file to Dropbox?


Hannah
Community Moderator @ Dropbox
dropbox.com/support


Heart Did this post help you? If so, give it a Like below to let us know.
:arrows_counterclockwise: Need help with something else? Ask me a question!
:pushpin: Find Tips & Tricks Discover more ways to use Dropbox here!
:arrows_counterclockwise: Interested in Community Groups? Click here to join!

Lyn14
Explorer | Level 4

Hi

I download the dropbox file to my computer to add information then I uplspreadsheet for rolling programme.jpgDropbox spreadsheet for rolling programme.jpgoad to the relevant folder on dropbox

Hannah
Dropbox Staff

Thanks for the screenshots, @Lyn14.

 

So, are you opening the file locally on your computer to edit it?

 

How does the file appear when you're previewing it on dropbox.com, does it have the correct date format there?


Hannah
Community Moderator @ Dropbox
dropbox.com/support


Heart Did this post help you? If so, give it a Like below to let us know.
:arrows_counterclockwise: Need help with something else? Ask me a question!
:pushpin: Find Tips & Tricks Discover more ways to use Dropbox here!
:arrows_counterclockwise: Interested in Community Groups? Click here to join!

Lyn14
Explorer | Level 4

Hi I sent 2 Screen Shots. I am at home when I open the spreadsheets 

1. is the computer shot - with the UK date format

2. is the same spreadsheet but up loaded into the dropbox which then changes the format USA

Hope I am explaining myself 

Walter
Dropbox Staff

Hey @Lyn14 - sorry to jump in here, but could you clarify if you're seeing this behavior with only this specific file or if it's affecting others as well?

 

Does your spreadsheet contain any macros by the way? 

 

Any additional information is more than welcome!


Walter
Community Moderator @ Dropbox
dropbox.com/support


Heart Did this post help you? If so, give it a Like below to let us know.
:arrows_counterclockwise: Need help with something else? Ask me a question!
:pushpin: Find Tips & Tricks Discover more ways to use Dropbox here!
:arrows_counterclockwise: Interested in Community Groups? Click here to join

Lyn14
Explorer | Level 4

Hi Walter, feel free to jump in.

We are volunteers for a charity Dog Rescue and using the Dropbox for up to date information, so not computer savy.  I do not think so to Macros.

There are only 2 spreadsheets on here and both have UK format for  the date both once uploaded to Dropbox change to the USA version,  This is confusing if the date UK 3/5/23 turns and shows 5/3/23 especially as we are transferring paper copies on to the computer, and then putting them into date order.

regardsLynn

Hannah
Dropbox Staff

Hi again, Lynn!

 

If you open the file from your account on dropbox.com (from any computer), how does it look? Does it have the correct date?


Hannah
Community Moderator @ Dropbox
dropbox.com/support


Heart Did this post help you? If so, give it a Like below to let us know.
:arrows_counterclockwise: Need help with something else? Ask me a question!
:pushpin: Find Tips & Tricks Discover more ways to use Dropbox here!
:arrows_counterclockwise: Interested in Community Groups? Click here to join!

Need more support?