Thread: How do I convert dates to text keeping the format?
View Single Post
  #2   Report Post  
N Harkawat
 
Posts: n/a
Default
=TEXT(A1,"MM/DD"/YYYY")

"sprlarry" wrote in message
...
I'm trying to convert a column of data in date format *m/d/yyyy to a text
format without converting to serial numbers. Ie: I want to retain the
mm/dd/yyyy format. Is there a way to do this?


Reply With QuoteReply With Quote