I have a question and really hope you guys could help me out. I made a certain custom field (with data type numeric) where is used an ID with 8 numbers ranging from 0-9. Unfortunately, in a numeric data type is the 0 is not taken into account hence some ID's are now 7 numbers without the 0 in the front.

Obviously the 0 has to be taken into account since it's the ID variable. Now I know I can't change the data type, but is there a way to duplicate that (numeric custom) field into a new (text custom) field for all my leads? Or at least the leads that have such an ID (not all; a couple of hundred).

I tried exporting a view, but that's not possible. Please help me out guys!      

Thanks in advance