I have a column of numbers on a sheet w/22,000 rows, I'm trying to truncate
the decimal. If I try =Trunc(a2,0) on 1.093 I get 1 which is what I want. But
if I copy the cell to fill the rest of the column, 0 will truncate to 1. What
am I doing wrong?
Thanks for any help,

You should not...

Do you mean to say that
=TRUN(0,0) is giving you 1?

Can you post the number which is truncating to 1?

I tried with
1.0989
2.0989
3.0989
4.0989
5.0989
0

and got
1
2
3
4
5
0



"Abbey Normal" wrote:

I have a column of numbers on a sheet w/22,000 rows, I'm trying to truncate
the decimal. If I try =Trunc(a2,0) on 1.093 I get 1 which is what I want. But
if I copy the cell to fill the rest of the column, 0 will truncate to 1. What
am I doing wrong?
Thanks for any help,

I wasn't including the number in the formula. I was including the cell, and
then copying it down the entire column. Is that not acceptable on this
formula?

"Abbey Normal" wrote:

I have a column of numbers on a sheet w/22,000 rows, I'm trying to truncate
the decimal. If I try =Trunc(a2,0) on 1.093 I get 1 which is what I want. But
if I copy the cell to fill the rest of the column, 0 will truncate to 1. What
am I doing wrong?
Thanks for any help,

I just gave that as an example... you can use cell reference in the formula
(as in any Excel formula)... I meant to say that does the cell with 0 is
giving you the problem when you use TRUN on it?

Pl. paste the no which is giving you trouble and the result.

"Abbey Normal" wrote:

I wasn't including the number in the formula. I was including the cell, and
then copying it down the entire column. Is that not acceptable on this
formula?

"Abbey Normal" wrote:

I have a column of numbers on a sheet w/22,000 rows, I'm trying to truncate
the decimal. If I try =Trunc(a2,0) on 1.093 I get 1 which is what I want. But
if I copy the cell to fill the rest of the column, 0 will truncate to 1. What
am I doing wrong?
Thanks for any help,