View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default Date Formating within a text cell

="..." & text(today(), "mmmm d, yyyy") & "...."



Rob wrote:

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


--

Dave Peterson