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