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]...
>
> 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
>
>
> --
> Freeman_100
> ------------------------------------------------------------------------
> Freeman_100's Profile:
http://www.excelforum.com/member.php...o&userid=33208
> View this thread: http://www.excelforum.com/showthread...hreadid=545264
>