Help with column

[lennymos123]

I have a datafeed that comes to me everyday i need to format one column

of around 1000 rows so it multiples the total column but a 1000 so
getting rid of the decimal point i.e =A3100.00 becoming 10000 , i also

need to do this using a macro. can anyone help=20


Regards=20

Paul

[Bob Phillips]

Dim iLastRow As Long
Dim i As Long

iLastRow = Cells(Rows.Count, "A").End(xlUp).Row
For i = 1 To iLastRow
Cells(i, "A").Value = Cells(i, "A").Value * 100
Next i

--
HTH

Bob Phillips

"lennymos123" <[email protected]> wrote in message
news:[email protected]...
I have a datafeed that comes to me everyday i need to format one column

of around 1000 rows so it multiples the total column but a 1000 so
getting rid of the decimal point i.e £100.00 becoming 10000 , i also

need to do this using a macro. can anyone help


Regards

Paul

[lennymos123]

cheers bob it worked perfect and helped me out alot

many thanks