Thread: Working with dates
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gary''s Student
 
Posts: n/a
Default Working with dates
Try:

=MID(A1,18,2) & "/" & RIGHT(A1,2) & "/" & MID(A1,13,4)
--
Gary's Student


"Sandy" wrote:

Hello
Cell A1 contains the text The date is 2005-11-21. In B1 I would like
11/21/2005.
WHat formula should I use
Thanks!
Reply With QuoteReply With Quote