Ask Search:
Helena LiuagHelena Liuag 

How do I convert the 15 digit SalesForce ID to an 18 digit

Is there a simple solution? Excel is not case sensitive which prevents me working on a lot of the data.

thanks,
Steve MolisSteve Molis
If you're on EE or UE you can do it in a Workflow Rule 

https://help.salesforce.com/apex/HTViewSolution?id=000005288&language=en_US
Craig HubertCraig Hubert
You can also research how to do case-sensitive comparisons in Excel.

http://support.microsoft.com/kb/214264