View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Sandy
 
Posts: n/a
Default Working with dates

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!