Convert Date to String

Michael168 · Oct 7, 2003

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

Thanks

JMay · Oct 7, 2003

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