If your values are really dates, you can change the format of those cells to
mmddyyyy.

If those values are just plain old numbers and those values are in a single
column, you can

Select the column
Data|Text to columns|Fixed width
(remove any lines that excel guessed)
and choose ymd as the order of the date.

You'll end up with real dates in those cells.

And now you can format them (format|cells|number tab|custom category) as:
mmddyyyy



Don wrote:

--
Don T

--

Dave Peterson