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?