Google Sheets TIps - Date Format Change

Описание: I created this video to answer a question one of my students had about formatting the date correctly. This won't apply to everyone, but I thought it might help somebody out there if I share it.

The formula works by keeping four spaces from the left, adding a hyphen, keeping the middle two characters starting from five spaces in, adding another hyphen, and keeping two characters from the right.

Here is my original response:

The problem I am seeing is with your original date format. When you type it in as "20170221", Sheets can't recognize that as a date and sees it strictly as a string of numbers. If you type it like this "2017-02-21", then format it as a date it will come out correctly with any date format you set it up with.

If you want to quickly add hyphens, you can use this function in an adjacent column.

=LEFT(C1,4)&"-"&MID(C1,5,2)&"-"&RIGHT(C1,2)

Replace "C1" with whatever your first date cell is, then copy the function all the way down the column. Once you have that set up, you can copy all of those cells and 'paste values' into your original date cells.

Get the Google Sheets and Forms course on Udemy: https://www.udemy.com/google-sheets-f...