Microsoft Office Tutorials and References
In Depth Information
Working with Dates: Dates Are Numbers Too
Figure 5–64. Dates on the menu: Date options in the Format Cells dialog box
Choose whichever option you like, and then click OK. They’re all different
guises for the same number. And note that when you click any of the
formatting possibilities, you’ll see a preview of what the date is going to
look like if you click OK, as in Figure 5–65.
Figure 5–65. What you see is what you are going to get: Previewing a data format. The Sample area reveals the
preview (see arrow).