Excel or Google Sheets may display dates in a way that you might not like. The good news is that you can change the date format to be whatever you want.
In Excel, press Ctrl + 1 (or Command + 1 on a Mac) and then go to the Custom section on the Number tab. From here, you can use any combination of m, d, and y along with dashes, commas and slashes.
In Google Sheets, you can also use the m, d, and y formatting to create custom date formats.
#excel #workhacks
Негізгі бет Create custom dates in Excel or Google Sheets
No video
Пікірлер