Naming Worksheets With Leading Zeros
Cell "A1" contains a number, say "10". The number format of that cell
is a custom number format ("000"). The value is displayed as "010" in
cell "A1".
Is there any code that will name the wrksht using the number in cell
"A1" and display that name on the tab as "010" rather than "10"? TIA
Mike Taylor
|