View Single Post
  #2   Report Post  
Piranha
 
Posts: n/a
Default


ML,
Keyboard shortcut to date stamp is put your cursor in the cell you want
and push -- ctrl ; --(thats ctrl and semicolon)
Time stamp would be -- ctrl shift ; -- (ctrl shift semicolon)
This help ?
Dave
- ML - Wrote:
I've created a lovely invoice in Excel for my company. When I generate
a new
invoice from the template it puts in the date using the TODAY()
function, but
unfortunately this updates if I ever open the invoice again to look at
it.

In Word there is a "CREATEDATE" function which inserts the date that
the
file was created first, and never after does it change. Is there any
way to
accomplish this same task in Excel?

Thanks,
Michael
mleenheer @ yahoo.com



--
Piranha
------------------------------------------------------------------------
Piranha's Profile: http://www.excelforum.com/member.php...o&userid=20435
View this thread: http://www.excelforum.com/showthread...hreadid=389913