One more thought.....

For a date in A1

You might be able to use this formula to achieve what you want:
B1: =TEXT(A1,"MMDDYYYY")

If A1 contains the date 9/16/2006
B1 returns 09162006 (as text)

Does that help?
***********
Regards,
Ron

XL2002, WinXP


"newguy" wrote:

I have a column that contains dates in this format mm/dd/yyyy. I need
mmddyyyy no slashs. If I do a custom format it still shows mm/dd/yyyy in the
the fx bar. I have tried using vbscipt replace method and copy the new date
to a different column but it drops the zeros no matter what the columns
format is. I need to create passwords from this column and I have to take out
the slashes.