View, download, and export
Need support with viewing, downloading, and exporting files and folders from your Dropbox account? Find help from the Dropbox Community.
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
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
Did this post help you? If so, give it a Like below to let us know.
Need help with something else? Ask me a question!
Find Tips & Tricks Discover more ways to use Dropbox here!
Interested in Community Groups? Click here to join!
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.
- - - -
Did this post help you? If so please mark it for some Kudos below.
Did this post fix your issue/answer your question? If so please press the 'Accept as Solution' button to help others find it.
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!
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.
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
Did this post help you? If so, give it a Like below to let us know.
Need help with something else? Ask me a question!
Find Tips & Tricks Discover more ways to use Dropbox here!
Interested in Community Groups? Click here to join!
Hi
I download the dropbox file to my computer to add information then I upload to the relevant folder on dropbox
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
Did this post help you? If so, give it a Like below to let us know.
Need help with something else? Ask me a question!
Find Tips & Tricks Discover more ways to use Dropbox here!
Interested in Community Groups? Click here to join!
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
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
Did this post help you? If so, give it a Like below to let us know.
Need help with something else? Ask me a question!
Find Tips & Tricks Discover more ways to use Dropbox here!
Interested in Community Groups? Click here to join
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
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
Did this post help you? If so, give it a Like below to let us know.
Need help with something else? Ask me a question!
Find Tips & Tricks Discover more ways to use Dropbox here!
Interested in Community Groups? Click here to join!
Hi there!
If you need more help you can view your support options (expected response time for a ticket is 24 hours), or contact us on X or Facebook.
For more info on available support options for your Dropbox plan, see this article.
If you found the answer to your question in this Community thread, please 'like' the post to say thanks and to let us know it was useful!