That won't "convert" the dates, just display them differently.

The underlying value will still be 09/20/08 or September 20, 2008

Do you need them actually "converted" to a text value of 080920 ?

="0"&(YEAR(A1)-2000)*10000+MONTH(A1)*100+DAY(A1)


Gord Dibben MS Excel MVP


On Mon, 21 Jan 2008 11:51:02 -0800, Julie
wrote:

Wow - easy - but I hadn't figured it out. Thank-you so much - you saved me
a ton of time!!!