Try
="Printed "&TEXT(TODAY(),"dd mmm yy")
Chang the dd and mmm etc to what you want to display,
Regards,
Alan.

"ForSale" wrote in
message ...

I put ="Printed " & today() in a cell thinking that the date would
update each time the sheet was opened. I'm having trouble formatting
the date, it keeps reading "Printed 38681". How can I change the
format the date to an understandable number?
If that is not possible, is there a more efficient way of achieving
what I am wanting?
Thanks,

Scott


--
ForSale
------------------------------------------------------------------------
ForSale's Profile:
http://www.excelforum.com/member.php...o&userid=11896
View this thread: http://www.excelforum.com/showthread...hreadid=488291