First i need to know how to pad the beginning of the number with the 0's. I am not sure of that. And secondly, how do i remove the decimal mark, but continue with the number string.

basically i am using a cell reference and then a format refernece in my VBA.... but i cannot get it working right.

If I use format "000000000000" I get this result 00000000000431 if i use the "#########" format i get this result 431 and and the excel number is 430.80939948 and it should be 0043080939948

Ideas on the VBA code to make this happen. Or if i can parse out the decimal in excel and add the padded 0 at the beginning?