"Dave Peterson" wrote:

=text(a1,"mmddyy")
if A1 contained the date

Or just format the cell using a custom format:
mmddyy



MICHALK wrote:

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.

--

Dave Peterson
.

THANKS SO MUCH!!