Hi
I'm trying to code a loop which runs through every cell in a specified column.
If the cell contains a number with 10 digits, then add "0" to the left side of the number.
For example 1126742873 = 01126742873
It's an emplyee-number and the zero has to be there, with usual formatting it gets wrong.
Anyone who can help with this?
Best regards
Stig
I'm trying to code a loop which runs through every cell in a specified column.
If the cell contains a number with 10 digits, then add "0" to the left side of the number.
For example 1126742873 = 01126742873
It's an emplyee-number and the zero has to be there, with usual formatting it gets wrong.
Anyone who can help with this?
Best regards
Stig