May 2011 Archives - JP Software Technologies

Ignore Conversations in Outlook 2003

May 30, 2011 by JP

Ignoring Conversation

Happy Memorial Day!

In Outlook 2010 there is a new feature that lets you "ignore" emails in a conversation — existing and future emails are sent to the Deleted Items folder.

This feature is great for inter-office Reply-To-All swarms, chain letters, joke forwards, and other types of email threads you wish would just go away.

Filed Under: Outlook

Tagged With: conversation, ignore

Convert Range to Numbers

May 16, 2011 by JP

5 Comment(s)

Lately I've been working with a spreadsheet that imports data from a database application (Access). The numbers are formatted as text because some of them contain letters. So the whole field has to be formatted as text.

Then again, I'm not sure if the text formatting is because of that, or if it's just a function of being a foreign data source.

Filed Under: Excel

Tagged With: convet, GTD, number

Two sorting macros

May 12, 2011 by JP

4 Comment(s)

When I'm doing a lot of sorting I use these two procedures to sort my used range. I've assigned them to toolbar buttons; just select the value you want to sort on and click the button to sort.

The first one sorts ascending; the second, descending.

Filed Under: Excel

Tagged With: GTD, sort