Thread: Convert Date to Text
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
HKaplan HKaplan is offline
external usenet poster
  
Posts: 80
Default Convert Date to Text
Try =TEXT(A1,"dddd mmmm yyyy")

Where A1 has the data info. You can change the display format, such
as dd/mm/yy or whatever you want.
Reply With QuoteReply With Quote