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?

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

Assuming text is in column A

In B1 enter =MID(A1,5,2)&RIGHT(A1,2)&LEFT(A1,4)

Copy down.


Gord Dibben MS Excel MVP



On Wed, 7 Feb 2007 12:20:02 -0800, 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?