I think just custom formatting the cell entry will do what you want.
Assuming that 7/17/08 is a real date (and not simply text), right-click the
cell and select Format Cells from the popup menu that appears, select Custom
in the Category listing and put mmddyyyy into the Type field.

Rick


"Melissa" wrote in message
...
How do I customize a Date

7/18/08

Should look like 07182008 and needs to be recognized as numbers.

Also, on my last questions about extracting the numbers only and filling
with zeros (10 places)

The formula that I was given recognized the data as text and I need it
recognized as numerical also. Can you Help?