Hello:
I need a VB Code to do the following:
I have data in column L thru ED.
I need code to format the data as follows.
M101 : M900 to no digit (Integer number)
Q101 : Q900 to no digit (Integer number)
M101 : M900 to no digit (Integer number)
Q101 : Q900 to no digit (Integer number);
until column EC
Then
N101 : N900 to 2 digit
Q101 : Q900 to 2 digit
M101 : M900 to 2 digit
Q101 : Q900 to 2 digit ;
until column ED
Please let me know if you have any questions.
Thanks.
Riz
Bookmarks