Convert Date to String
 

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

Thanks



------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/

Convert Date to String
 

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

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

Thanks



------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/