VB Code to format data

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

Hello:

I am coming across lots of files like this on daily basis and need an easy way since this will require to select lots of data.

Thanks

Riz

Hello;

Oh I see your point.....it was my error about the data
Please let me correct as below..

I have data in column L thru ED.
I need code to format the data as follows.
M101 : M900 to no digit (Integer number) Example 123
Q101 : Q900 to no digit (Integer number)
U101 : U900 to no digit (Integer number)
Y101 : Q900 to no digit (Integer number);
until column EC

Then
N101 : N900 to 2 digit example 123.45
R101 : R900 to 2 digit
V101 : V900 to 2 digit
Z101 : Z900 to 2 digit ;
until column ED

Basically every 4th column

Once again i just realized my mistake and would appreciate your help.

Thanks

Riz

Hi Robert:

Thanks a lot, it works great for me.

Riz