Thread: Convert Date to String
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
JMay JMay is offline
external usenet poster
  
Posts: 422
Default 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/



Reply With QuoteReply With Quote