how to do it without rounding off
 

Excel Expert, please help :)

may I know how I can retain number like

11.82 as 11
0.63 as 0

without rounding off to 12 and 1 respectively ?

I understand that I can first round off the number and then minus one.
but the problem is I have other number like 0.23, if I round off then
minus one, it will turn to -1

I got thousand of these numerical data, what can I do? :confused:


--
ToMmY2
------------------------------------------------------------------------
ToMmY2's Profile: http://www.excelforum.com/member.php...o&userid=27610
View this thread: http://www.excelforum.com/showthread...hreadid=471334

Hi

Try =INT(A1)
where A1 holds your number

Regards

Roger Govier


ToMmY2 wrote:
Excel Expert, please help :)

may I know how I can retain number like

11.82 as 11
0.63 as 0

without rounding off to 12 and 1 respectively ?

I understand that I can first round off the number and then minus one.
but the problem is I have other number like 0.23, if I round off then
minus one, it will turn to -1

I got thousand of these numerical data, what can I do? :confused:

Check out the ROUND function, this should give you all the options
you'll ever need

Cheers
Jon


--
Jon Quixley
------------------------------------------------------------------------
Jon Quixley's Profile: http://www.excelforum.com/member.php...o&userid=25803
View this thread: http://www.excelforum.com/showthread...hreadid=471334

Oh, I cannot believe it's that simple! haha

thank you


--
ToMmY2
------------------------------------------------------------------------
ToMmY2's Profile: http://www.excelforum.com/member.php...o&userid=27610
View this thread: http://www.excelforum.com/showthread...hreadid=471334