Convert Date to String

[Michael168]

How to convert the cell value in date format into a string format.
e.g.
10/07/03 change into 100703

Thanks

 

[JMay]

In B1 enter
=TEXT(A1,"mmddyy")
where A1 = 10/07/03
HTH