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

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?

All comments

Mark

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.

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

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

Also, how are you adding the file to Dropbox?

I download the dropbox file to my computer to add information then I upl spreadsheet for rolling programme.jpg Dropbox spreadsheet for rolling programme.jpg oad to the relevant folder on dropbox

Hannah

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?

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!

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

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?

Dropbox spreadsheet for rolling programme.jpg

This is a copy of the spreadsheet from Dropbox. Before uploading the date format in the columns were in the UK format

Th spreadsheet for rolling programme.jpg

This is the same spreadsheet that is on the computer, with correct date format

Hi from me too, @Lyn14! If you haven’t tried this already, can you please clear your browser’s cache/browsing data and then re-upload the file to Dropbox?

If this doesn’t work, I’d also like you to take one extra step with me, and re-upload the file to Dropbox via an incognito/private window on your Microsoft Edge browser.

Does that seem to help at all?

Hiya thanks for trying to help. Have cleared all the history and up loaded it again and its still the same.

Not sure what you mean about private window.

regards

Thanks for giving that a try!

If you open Microsoft Edge, there should be three dots in the upper right corner of your window. Please click there and select the “New InPrivate Window”.

Do you see any difference, if you re-upload your file to the Dropbox website from there?

Hi Nancy

Sorry, still no difference.

Hey @Lyn14 - sorry to jump in here, but could you clarify if you're previewing the file on the Dropbox website directly or if you're opening it through the Excel integration instead?

I download from Dropbox to my computer update. Once finished the date is UK format, I up load from Excel to Dropbox - view in Dropbox and format is changed.

Could you maybe send us a full screen screenshot so that we can distinguish where you're previewing the file from @Lyn14?

is this what you after? screenshot for dropbox.jpg screenshot for dropbox2.jpg

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, thankyou. Yes I was viewing in the Dropbox. I thought that because I was just "looking" it was okay.

Thanks everyone for taking time to help me,

Mark, Thanks for helping. This is what I was doing wrong, thought it might help you

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?

Walter thank you for trying to help - a solution was found - thought you might want to know

regards Lynn

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?