Thanks for the response, but I seem to be doing something wrong and I'm not
sure what.

As an example of my data, I have a cell that contains today's date as
20060214, and I would like to convert it to 02142006. I tried entering a
custom format of mmddyyyy and my cell converted to #######. I tried using
some of the preset choices for Date and got the same result. Not sure where
I'm going wrong here...

Again, thanks for all of the help!


"serious" wrote:

High all the cells to which you wish this to apply. Go to Format, go to
Cell, go to the Number tab, go down to Date, on the right scroll to the
format you'd like and highlight/click it. If none of those meet your need,
on the left go down to Custom, enter the letters representing the date format
you want (as you did in your request) and hit enter.