Select the date you want to format. The Ctrl+1. Select Numbers tab. Select
custom. In the "Type:" box enter the format you want - e.g. m/d/yyyy or
select one of the existing formats. See Excel help for the possible formats
you can use.

Tyro


"Kathy" wrote in message
...
I have a similar question...how can you set a new Custom date in the cell
format application?
--
Thanks, Kathy


"Gord Dibben" wrote:

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!!!