View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Rob Rob is offline
external usenet poster
 
Posts: 718
Default Date Formating within a text cell

How can I format the date to display "March 1,2010" in the following formula?
="Volume moved between February 10, 2010 and "&TODAY()&" as determined"
current result is = Volume moved between February 10, 2010 and 40238 as
determined