="Printed " & today()

[Paul B]

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]

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

 

[Alan]

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

 

[ForSale]

Thanks a lot, everyone.