If you select the cells you want in date format, then right click on
them and select Format Cells and select the "number" tab, then select
Category, Date, you'll see all the date formats that come with XL. I
used to know how to create custom date formats, but it's been so long,
I don't remember how any more.
