View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Mike Taylor Mike Taylor is offline
external usenet poster
 
Posts: 17
Default 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