Hi all,
I have about a 1000 cell filled with info. Some cells contain 3 digits other contain 4 digits. What I want for the 3-digits cell is that a 0 is added before the digits.
Like this:
9878 9876 876 123
Becomes:
9878 9876 0876 0123
I uses the custom format function with "0000" as custom, this works, but only if you define this on forehand, not afterwards. Defining it on forhand unfortunately does not work because the cell get their content from a userform which seems to distort the cell format somehow.
Can anyone give me a clue?
thanks a lot.
Dinictus.
I have about a 1000 cell filled with info. Some cells contain 3 digits other contain 4 digits. What I want for the 3-digits cell is that a 0 is added before the digits.
Like this:
9878 9876 876 123
Becomes:
9878 9876 0876 0123
I uses the custom format function with "0000" as custom, this works, but only if you define this on forehand, not afterwards. Defining it on forhand unfortunately does not work because the cell get their content from a userform which seems to distort the cell format somehow.
Can anyone give me a clue?
thanks a lot.
Dinictus.