| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| leading zeros | New Users to Excel | |||
| Leading Zeros | Excel Discussion (Misc queries) | |||
| Leading zeros | Excel Discussion (Misc queries) | |||
| Leading zeros | Excel Discussion (Misc queries) | |||
| save text field w/ leading zeros in .csv format & not lose zeros? | Excel Discussion (Misc queries) | |||
Hybrid Mode
