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