Microsoft Office Tutorials and References
In Depth Information
Using Formatting with Dates
Using Formatting with Dates
Dates are particularly troublesome. For example, in Figure 2.11 , a date of
birth appears in column E with the format of YYYYMMDD. If you type 3/5/
3/5/
1970
1970 in G2 and then press the Flash Fill icon, Excel does not correctly re-
cognize the pattern. You get 3/5/ and the first four digits from E in each row.
This is an interesting result. You can sort of understand how Excel was
tricked into seeing the wrong pattern.
Figure 2.11.
Figure 2.11. The real problem is you are missing the leading zero.
The real problem is you are missing the leading zero.
You can solve the date problem by formatting the column to show MM/DD/
YYYY first. Here s how:
11. Select column G.
22. Press Ctrl+1 to display the Format Cells dialog.
33. On the Number tab, choose the Date category.
Search JabSto ::




Custom Search