I want to format my date from 1/24/2006 to 1242006

In code
============
YourDate = "1/24/2006"
CodedDate = Format$(YourDate, "mddyyyy")

On the sheet
============
Select cell or column, right-click and select Format Cells, select Custom
from the Category list on the Number tab, and put mddyyyy in the Type field.

Rick