date format
 

How do I change "2006/10/02" to "20061002"

date format
 

If you are simply talking about how a date is displayed:

If it is formatted as yyy/mm/dd, Format as yyymmdd

If it is formatted as yyy/dd/mm, Format as yyyddmm

(I can't tell from the example)

Regards

Trevor


"EdJack" wrote in message
...
How do I change "2006/10/02" to "20061002"

date format
 

If it is a string, then

=SUBSTITUTE(A1,"/","")

--

HTH

Bob Phillips

(replace xxxx in the email address with gmail if mailing direct)

"EdJack" wrote in message
...
How do I change "2006/10/02" to "20061002"