Copy data in a cell to the worksheet name with leading Zeros

Hi Guys,

I am trying to take the value of a cell and use it to name the worksheet. The value in question will always have atleast one leading zero.

In the source cell i have already set up the formatting so that the leading zeros are there.

When i use the cell to set the ShtName it does not bring along the leading zeros.

the value in the cell for example would be 01520012015 but when i use the same cell to name the worksheet it only gives me 1520012015 with no leading zero.

Does anyone know how i can take the value to set the ShtName and have the leading zeroes there?

Thank you in advance

Provided your formatting is as Mumps indicated, I assume you are doing something like this with your code

Please Login or Register  to view this content.

Here's what I've done in a similar situation…

Please Login or Register  to view this content.

This way, no apostrophe is needed which would make that data Text rather than Numeric, and might affect other references to cell A1.
All sheet names done this way would have the same length, 12 characters in this example.
You could also get more creative in the format, perhaps a space after every 4th digit, which may make them easier to interpret. Just a thought.

Hope this helps,
- Stu