Issues with Environ vba script

Hi,

When a user launches my spreadsheet the following code is activated (a section of it):

Please Login or Register  to view this content.

The problem is users log on with 5 digits i.e 12345. However some usernames start with a 0 for example 01234. When that code is called the cell shows the value without a zero.

Can I either add to the code to force this to happen. Or is there a way to force the cell to show 5 digits?

Thank you in advance.

maybe

Please Login or Register  to view this content.

Roy, I've even tried that, and if the cell is formatted as General (or anything other than Text), the leading zeros are still dropped. I got the following to work, though:

Please Login or Register  to view this content.

Essentially setting the cell format to text first, which could be done manually I suppose.

You could use a Custom Format on the cell of 00000, this will write back the value as a number but display leading zero.

Please Login or Register  to view this content.