You need to sign in to do that
Don't have an account?

How to use Excel Connector to turn 15 digit IDs into 18 digit IDs?
I have been unable to ascertain how to use the Excel Connector to turn 15 character IDs in an Excel spreadsheet into 18 character IDs, which is something I read was possible on a forum post. I've watched the videos and searched the forums. I know the function "FixID" is involved, but I'm unable to make it work. I've installed the toolkit and correctlt installed the connector, but that's as far as I've gotten.
Could someone please dumb this down for me with step by step instructions?
Here's an example:
Rhonda
There's nothing special you need to do - just typing the formula should do it.
I would check two things:
1. Make sure that you don't have Excel setup to display formulas instead of results of the formulas.
2. Make sure that the field you typed the formula into started off as truly empty, not just looking empty. One way to test this is insert a new column and then type in the formula.
Oh -- a third thing. Do make sure that you are telling Excel that this is indeed a formula. Do that by typing = before you type fixid(cell ref).
Rhonda
I too cannot make this formula work. I have checked all the fixes suggested and saved the file as a CVS file; still no luck.
One more thing to check - make sure the cell type is set to "General" and not to "Text" or "Number".
https://code.google.com/p/excel-connector/wiki/Install