View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
ForSale
 
Posts: n/a
Default ="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