How can I change NOW() to a date when combined with text?
Thank you Pete_UK for your brain power and surprisingly quick answers. Man am
I impressed. Oh yea: All of the answers worked great.
«¤»¥«¤»
David
«¤»¥«¤»
"Pete_UK" wrote:
Do it like this:
="^ ^ ^ 2008 Info Current As Of "&TEXT(NOW(),"dd/mm/yyyy") &" ^ ^ ^"
Hope this helps.
Pete
"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()) &(" ^ ^ ^")
|