="Printed " & today()

[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

[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" <[email protected]> wrote in
message news:[email protected]...
>
> 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
>

[Alan]

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

"ForSale" <[email protected]> wrote in
message news:[email protected]...
>
> 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
>

[ForSale]

Thanks a lot, everyone.