Ok, the code I am using is


MkDir ("C:\" & [B12] & "\" & [B13] & "\" & [B14])
Now B14 is formatted as 000, but even though it shows 009 on the cell, it creates the folder as just 9. Is there a way to make the folder be named 009.

Thanks