Standard date- and time-entry options and acceptable alternatives

…When you're entering dates and times in Excel, there…are standard suggested ways to make this most efficient.…With dates, you want to use a slash or a dash.…Now, in cells A2 and A3, these were actually entered as text, the little…triangles that you might see in the upper left corner are simply warnings here.…If you happen to click one of these cells,…you'll see a little exclamation point to the right.…It simply reminds us that, it says the cell contains the…date string being represented with only two digits for the year.…Nothing wrong with that, by the way.…But when you make a standard data entry, let's say we use a slash here.…

Suppose it's March 4th of the year 2014.…This would be the standard way, the way most people in…the United States that is, would enter this bit of information.…And as we press enter, we see a four digit year.…If you use a dash instead, the same display will occur and you…probably wouldn't mix them at the same time, but you can do that.…But as I press enter here, we're going to get…