Thread: How can I change NOW() to a date when combined with text?
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
djenk2 djenk2 is offline
external usenet poster
  
Posts: 4
Default How can I change NOW() to a date when combined with text?

Thank you Glenn for your brain power and surprisingly quick answers. Man am
I impressed. Oh yea: All of the answers worked great.

«¤»¥«¤»
David
«¤»¥«¤»
"Glenn" wrote:

djenk2 wrote:
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()) &(" ^ ^ ^")


="^ ^ ^ 2008 Info Current As Of "&TEXT((NOW()),"MM/DD/YY") &(" ^ ^ ^")

Reply With QuoteReply With Quote