how do I change the date format
 

I need to change the date format from 01/01/2006 to 20060101 - please help.

how do I change the date format
 

yyyymmdd

Steve

On Wed, 22 Nov 2006 13:59:01 -0000, Raich
wrote:

I need to change the date format from 01/01/2006 to 20060101 - please
help.

how do I change the date format
 

=20000000+(YEAR(A5)-2000)*10000+MONTH(A5)*100+DAY(A5)


Gord Dibben MS Excel MVP

On Wed, 22 Nov 2006 05:59:01 -0800, Raich
wrote:

I need to change the date format from 01/01/2006 to 20060101 - please help.

how do I change the date format
 

You can change the format so that the value is kept a date, but is displayed the
way you want.

Or you could use a formula in another cell:

=text(a1,"yyyymmdd")
that will return a string.

or
=--text(a1,"yyyymmdd")
that will return a number.

Raich wrote:

I need to change the date format from 01/01/2006 to 20060101 - please help.

--

Dave Peterson