Thread: How can I change NOW() to a date when combined with text?
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Peo Sjoblom[_2_] Peo Sjoblom[_2_] is offline
external usenet poster
  
Posts: 964
Default How can I change NOW() to a date when combined with text?
You already got the answer but unless you need the time you are better off
using TODAY() instead of NOW

--


Regards,


Peo Sjoblom

"djenk2" wrote in message
...
How can I get the NOW() to display a date and not a number? Cell is
formated
in date format. THANKS to the brain that figures this one out.

="^ ^ ^ 2008 Info Current As Of "&(NOW()) &(" ^ ^ ^")


Reply With QuoteReply With Quote