EASY: Format NOW as mm/dd/yyyy
 

I have this simple function:

="Sales of: " & NOW()

But this way the date is appears with that Excel code like
33046,30184. I wanted to show 04/28/2006.
What is the function to set a format for the variable?

Something like =formatdate(now();mm/dd/yyyy)

Thanks!


--
pauloreiss
------------------------------------------------------------------------
pauloreiss's Profile: http://www.excelforum.com/member.php...o&userid=29820
View this thread: http://www.excelforum.com/showthread...hreadid=537287

EASY: Format NOW as mm/dd/yyyy
 

One way:

="Sales of: " & TEXT(TODAY();"mm/dd/yyyy")


In article ,
pauloreiss
wrote:

I have this simple function:

="Sales of: " & NOW()

But this way the date is appears with that Excel code like
33046,30184. I wanted to show 04/28/2006.
What is the function to set a format for the variable?

Something like =formatdate(now();mm/dd/yyyy)

Thanks!

EASY: Format NOW as mm/dd/yyyy
 

Actually, you're pretty close....try this:

="Sales of: " & TEXT(TODAY(),"MM/DD/YYYY")

Does that help?

Regards,
Ron


--
Ron Coderre
------------------------------------------------------------------------
Ron Coderre's Profile: http://www.excelforum.com/member.php...o&userid=21419
View this thread: http://www.excelforum.com/showthread...hreadid=537287

EASY: Format NOW as mm/dd/yyyy
 

That worked out!
Thanks a lot!!!


--
pauloreiss
------------------------------------------------------------------------
pauloreiss's Profile: http://www.excelforum.com/member.php...o&userid=29820
View this thread: http://www.excelforum.com/showthread...hreadid=537287