I've already done Format > Number > More Formats > More Date and Time formats for the entire column but the new date entries are still not auto formatted, how can I make it auto format?

Here's the spreadsheet: https://docs.google.com/spreadsheets/d/1O1rZUstDNSXPdUVXvaDfPO4rAQs2cJWHimfGxbddtNU/edit#gid=0

enter image description here

  • can you share a copy of your sheet?
    – user0
    May 28, 2019 at 0:52
  • @user0 sure, it's shared in post and is editable
    – sojim2
    May 28, 2019 at 1:23

1 Answer 1

  • select A7 cell
  • press CTRL + C
  • select A8 cell or A8:A range
  • press CTRL + LEFT ALT + V


  • to make it automatic after you pre-format the range you need to input hours too like:

    2/2 8:00
    5/28 0:00

  • But how do I make it so it auto formats it like excel? I'd have to do this each time if datetime is entered manually? I believe we can do it automatically with onEdit, but prefer not to go there.
    – sojim2
    May 28, 2019 at 1:32
  • @sojim2 answer updated
    – user0
    May 28, 2019 at 1:50

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.