You should've explained to our fellows that the multiplier is actually 10², not 2, although I understand that you have to use 2 to match your colorcode. It's kinda ghetto solution but it should work. Try to declare the number as a string, so you can use len() and left() functions properly. If you use the len() function on that string it will return the multiplier + 2. For example: Len("1000") returns 4, so the multiplier is 4 - 2 = 2 Then using Left("1000",1) and Right(Left("1000",2),1) returns the first and second digits respectivly Sure there are some other ways that envolve more math, but if you don't have any restrition (like the resistance HAVING to be an integer) it'd work just fine