how to do it without rounding off

[ToMmY2]

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 the
minus one, it will turn to -1

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

 

[Roger Govier]

Hi

Try =INT(A1)
where A1 holds your number

Regards

Roger Govier

 

[Jon Quixley]

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

Cheers
Jo

 

[ToMmY2]

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

thank you