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

Naming Worksheets With Leading Zeros
 

Hi
try something like
activesheet.name = format(Range("A1").value,"000")

--
Regards
Frank Kabel
Frankfurt, Germany


Mike Taylor wrote:
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