Converting 15 Digit ID to 18 Digits Case Sensitive ID

Just found this great video that walks you through how to convert 15 digit SF Ids to 18 digits so they will be case sensitive. The 15 digit Salesforce Id that you see in reports is not case sensitive therefore it can not be used in vlookups with excel or any other program that requires case sensitivity. The 18 digit Salesforce Id however IS case sensitive, so this is a little video that shows you how to convert it...

http://www.blog.bdgreen.it/2011/01/09/salesforce-ids-and-the-15-18-digit-problem/

If you are working with data already in Salesforce and need to convert the 15 digit SF ID to 18 there is a formula field function called CASESAFEID(id) that will display the SF ID as a 18 digit case sensitive id in Salesforce.