change 04/02/07 to 040207

change 04/02/07 to 040207 · May 18, 2007

How do I can the cell to display change 04/02/07 as 040207

Mike H · May 18, 2007

I assume it's a date and not text so try a custom format of

ddmmyyyy

Mike

CLR · May 18, 2007

And if it IS text..........

=LEFT(A1,2)&MID(A1,4,2)&MID(A1,7,2)

Vaya con Dios,
Chuck, CABGx3