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

=ROUND(A1,0)

and copy down

--
HTH

Bob Phillips

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

"Freeman_100"
wrote in message
...

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