need help

[Freeman_100]

Hi all

I am new in using macros and I ve a column of datas numbers and I would
like to do the following :
for exemple 1.85 go to 2, 1.15 go to 1, 4.45 go to 4 etc
waiting for your help buddies
regads

 

[Bob Phillips]

=ROUND(A1,0)

and copy down

--
HTH

Bob Phillips

(replace xxxx in email address with googlemail if mailing direct)

"Freeman_100" <[email protected]>
wrote in message
news:[email protected]...