Hi all,
I have the following code in a module, which I call from another code:
Please Login or Register to view this content.
The values in column E varies in length from 1 to 10 numeric characters, e.g., 1234567, or (in a very few cases), consist of 15 alphanumeric characters – e.g., 00000000A987654.
The code is formatting column E to number format “0000000000” but the alphanumeric values still show the 15 characters.
I tried to modify it as follows:
Please Login or Register to view this content.
But it is not working.
Can someone help me fix it, please.
Thank you,
Gos-C
Bookmarks