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?