If the those dates are in a single column, it would be quicker to:

Select that column
Data|Text to columns
Fixed width
remove any lines that excel guesses
choose date (ymd)
and plop it back where it came from.

Then format those cells as mmddyyyy
(format|cells|Number tab|Custom category)

Renetta wrote:

I have a file received via Excel with dates formated as 19840719 I would like
it to reflect as 07191984. is there a way to write a formula to change and
or change?

--

Dave Peterson