How can I change NOW() to a date when combined with text?
 

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

How can I change NOW() to a date when combined with text?
 

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

How can I change NOW() to a date when combined with text?
 

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

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

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

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

How can I change NOW() to a date when combined with text?
 

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

«¤»¥«¤»
David
«¤»¥«¤»

"Peo Sjoblom" wrote:

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

How can I change NOW() to a date when combined with text?
 

Well, thanks for feeding back, David.

Pete

On Sep 24, 7:01*pm, djenk2 wrote:
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()) &(" * ^ ^ ^")- Hide quoted text -

- Show quoted text -