First thing's first: my spreadsheet's locale is properly set to UK:
If I paste in the following date:
30/09/2013 21:15
Then click Format > Number > Date time
Nothing changes. I also can't seem to sort by date.
Web Applications Stack Exchange is a question and answer site for power users of web applications. It only takes a minute to sign up.
Sign up to join this communityFirst thing's first: my spreadsheet's locale is properly set to UK:
If I paste in the following date:
30/09/2013 21:15
Then click Format > Number > Date time
Nothing changes. I also can't seem to sort by date.
This has now been resolved by Google Spreadsheets. Pasting in the date:
30/09/2013 21:15
And clicking Format > Number > Date time now immediately turns the cell into a date time cell (you can see this as it adds seconds).
30/09/2013 21:15
you're pasting in IS in dd/mm/yyyy. It matches the date time format in the drop down. – phantom42 Jan 27 '14 at 17:56