="Printed " & today()
 

ForSale, try something like this,

="Printed " & TEXT(TODAY(), "MM/DD/YYYY")

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"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

="Printed " & today()
 

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

="Printed " & today()
 

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

="Printed " & today()
 

Thanks a lot, everyone.


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