View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Tim879 Tim879 is offline
external usenet poster
 
Posts: 208
Default Inserting " in a formula

="The date today is "&""""&TEXT(TODAY(),"dd-mmm-yyyy")&""""

On Aug 13, 8:34*am, FARAZ QURESHI
wrote:
How can I insert inverted commas in a formula. For example:
="The date today is "&TEXT(TODAY(),"dd-mmm-yyyy")
reflects:
The date today is 13-Aug-2008
but how can I achieve a result like:
The date today is "13-Aug-2008"

--

Best Regards,
FARAZ A. QURESHI