Use the text function, as in:
=text(a1,"mmddyy")

Regards,
Fred

"MICHALK" wrote in message
...
How do you change a date to text and return a string such as mmddyy to
replace 01/01/10? In other words remove the slashes but keep the same
numbers.