First thing's first: my spreadsheet's locale is properly set to UK:

enter image description here

If I paste in the following date:

30/09/2013 21:15

Then click Format > Number > Date time

enter image description here

Nothing changes. I also can't seem to sort by date.

  • Maybe I'm missing something, but the 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, 2014 at 17:56
  • 1
    If I paste in your date after changing the spreadsheet settings it works fine for me. Alternatively try setting the number format of the cell first and then pasting in the data.
    – zelanix
    Jan 28, 2014 at 2:23
  • @phantom42 Google spreadsheets adds seconds if it parses the date properly (note I originally said 'milliseconds', this isn't correct). I've re-tested on the latest Google Drive and pasting then changing the format works now. Apr 20, 2014 at 21:52

1 Answer 1


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).

enter image description here

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.