View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
AuthorizedUserPF AuthorizedUserPF is offline
external usenet poster
 
Posts: 11
Default Trim varying decimals from column of numbers

Good Morning
I am using Excel 2003 and have a column of approximately 250 numbers. Each
has different number of decimals. Although the Format displays all as whole
numbers, the decimals are be calculated and throowing my cost analysis off
when Multplying this column (Quantity) x a Price. How can I trim all values
to whole numbers, regardless of their vary number of decimal places.

Thanks in Advance
Phil