date formula question

A

ABASSANETTI

Does anyone know how to change the date format in excel to read (ie
20020429 instead of 04/29/2002..... Is there a formula or something
I tried changing the date format and it doesn't have the format
need.... Please hel
 
A

Andrew

Right-click the cell you want to change, select the Format Cell dialo
box , then the Number tab, then Custom, enter yyyymmdd then push OK.

HT
 
D

Deb

-----Original Message-----
Does anyone know how to change the date format in excel to read (ie)
20020429 instead of 04/29/2002..... Is there a formula or something?
I tried changing the date format and it doesn't have the format I
need.... Please help


---


.
Go to format cells and select custom. In the box under
Type: type in yyyymmdd.
 
Top