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