I used the following in Excel 2003 but it give a 'Compile Error: Can't find project or library' in Excel 2007
Any help would be appreciated

If Left(iVal, 2) <> "00" Then
iVal = "00" & iVal
ElseIf Left(iVal, 1) <> "0" Then
iVal = "0" & iVal
End If