I want to display a date in Google Sheets as Month-Day (e.g. Jan-10) with the underlying data as: 2021-01-10

However in order to show Jan-10, Google Sheets defaults the underlying data to 01/10/2021 instead.

enter image description here

  • Welcome. Please remember that as per site guidelines when an answer addresses your question, you should accept it so others can benefit as well. Jan 20, 2021 at 18:08

2 Answers 2


Just change the format by going to
Format >Number >More Formats >More date and time formats and choose or create the one that meets your needs.

enter image description here

  • Notice your underlying data is 1/10/2021? How can that be changed?
    – Techcrium
    Jan 22, 2021 at 13:52
  • This is what your question is about: I want to display a date... with the underlying data as: 2021-01-10 Also: "However in order to show Jan-10...". So your question is answered. As for your comment on how to change the underlying data, you cannot. In any case I believe you should accept the answer so others can be helped as well. Jan 22, 2021 at 17:05

Google Sheets manages dates as serial-numbers, meaning that a date (as well a date-time, time, duration) are internally managed as numbers and what you see depends on the spreadsheet regional settings and the cell formatting.

You can find the explanation made by Google on Date and Number Formats

Other resources


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.