>However if I were doing it I'd try to change the data to A0001, A0014, A0100, etc. on import/addition. Then it would automatically index correctly.

I was thinking break it up, the leading digit could be a department type identifier, and the numbers after would be the actual key. Just a thought.