I want to display a date in Google Sheets as Month-Day (e.g. Jan-10) with the underlying data as:
However in order to show
Jan-10, Google Sheets defaults the underlying data to
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 community
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