View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Abbey Normal Abbey Normal is offline
external usenet poster
 
Posts: 16
Default Problems truncating a column

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,