cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Announcements
Update: Find information on Dropbox support during COVID-19 here
Close

Dropbox installs & integrations

Connect your tools and content together with help from the Dropbox Community. Join a discussion or post a question of your own to get started.

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

Excel UK date entry falsely correcting!

New member | Level 2
New member | Level 2

I have a spreadsheet, as is quite common it has a column for date. I select the whole column, right click to change Number Format as would be expected. I set this to Date, set the local to English (UK) and then set the format to be dd/mm/yyyy as we would epxect to see it.

 

Now every time I enter the date dd/mm in one of the fields it incorrectly believes I am entering it in mm/dd format and swaps around the day and the month if both are below 12 or makes no changes (and doesn't add the year) if the dd is over 12. This is clearly very incorrect!!!

 

My computer Locale is correctly set to UK already, which is what you claim it uses to assume what the entry format would be in.

 

Please sort this out. Verry annoying!!

1 Accepted Solution

Accepted Solutions
Highlighted

Re: Excel UK entry falsely correcting!

Super User II
Super User II
This won't have anything to do with Dropbox. You're in Excel, which is a Microsoft product (even if you're using Office Online through Dropbox, it's still Microsoft). Dropbox has no control over how it functions. You'll need to ask this question on a Microsoft forum or contact Microsoft Support.

View solution in original post

2 Replies 2
Highlighted

Re: Excel UK entry falsely correcting!

New member | Level 2
New member | Level 2

Also once I have changed the Date Format to a Locale of Engligh(UK) if I then go back and check the format the locale has changed to Armenian! Not right!! Although it still says the requested date format is correct so this should still work......

Highlighted

Re: Excel UK entry falsely correcting!

Super User II
Super User II
This won't have anything to do with Dropbox. You're in Excel, which is a Microsoft product (even if you're using Office Online through Dropbox, it's still Microsoft). Dropbox has no control over how it functions. You'll need to ask this question on a Microsoft forum or contact Microsoft Support.

View solution in original post

Polls
Do you know how to organize your files and folders?
We have created a guide on folder best practice, so you can get organized now check it out here.

Work Smarter with Dropbox

The way we work is changing. Share and discover new ways to work smarter with Dropbox in our community.

Sound good? Let's get started.
Who's talking

Top contributors to this post

What do Dropbox user levels mean?
Need more support?