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.

"arem" wrote:

Hello All - I have a document that has a column of dates all formatted
yyyymmdd. I need to convert these to the US standard mmddyyyy format. Can
anyone please tell me an easy way to do this in Excel 2003? All help is much
appreciated, thanks!