Replies

Here’s one I have used and modified a number of times:
http://www.mvps.org/skp/ppt00023.htm%5B/url%5D

=MIN(IF(Range0,Range,FALSE)) this is an array formula. Enter using Ctrl+Shift+Enter
Also see:
http://www.cpearson.com/excel/lists.htm

Ctrl + :
will insert today’s date
Ctrl + ;
Inserts the current time

It don’t

Delete
~*.*
files. Theses are the TMP files Word leaves like shards wherever the documents have been stored

Thanks! I always like it when the answer is “click the big red button that fills half the screen!”

The Old shortcuts I learned in Access:
Ctrl + ; Current date
Ctrl + : Current time
Ctrl + ‘ Duplicate the preceding entry

Check Format>Style and click on Modify. Make sure that Automatically update is not checked. An Auto update changes the style whenever a manual adjustment is made to an entry.

Use PowerPoint

Go to Tools>Options Calculation and turn off Precision as displayed

The contents of fields can be replaced. If you use Alt+F9 you can then use Edit>Replace. To replace Control codes, you need to enter the correct characters. For a linefeed the code is ^11. See TechNet Q95474

PowerPoint has never (until now) had password protection. It is available in PowerPoint 2002.

Try here.

There’s a product called PrezGuard Pro http://www.aladat.com/. There is also a discussion at this PowerPoint FAQ.

If you’d like to see a great discussion of date intervals, go to Chip Pearson’s web site.