Retaining leading zero in macro

All, I have a cell in my workbook that contains the number 8, though due to the formatting on that cell it appears as "008", as it should. However when I try and use that number in my macro it becomes "8" again, is there a way of retaining the leading zero's?

I tried:

CCD = Format(Cells(3, 2), "000")