Thread: CONCATENATE TODAY()
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Charlie Bravo Charlie Bravo is offline
external usenet poster
  
Posts: 1
Default CONCATENATE TODAY()
Hi,

I am using the formula =CONCATENATE("Results as of "&TODAY()) but the date
comes out as a number. How can I get it to display as a formatted date so it
looks like "Results as of January 29, 2007"?

Charlie
Reply With QuoteReply With Quote