Thanks for the information. It is (as Bob Phillips mentioned in my
other post- again sorry for the multple posting, no messages were being
posted for about 2 hrs) that each digit was being multiplied by 1 so
the 12. * 1 = 12, then the next digit came along 123*1=123. I am
pretty familier with typical excel things, such as formatting, but am
just starting to get a grasp of the power of VB in excel. Looking
foward to learning more about it. Hopefully soon I will be able to be
creating my own instead of modifying other's functions.

-Andrew V. Romero