Trim varying decimals from column of numbers

A

AuthorizedUserPF

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
 
T

T. Valko

the decimals are be calculated

If these numbers are the results of formulas then try something like this:

=INT(your_formula_here)
 
A

AuthorizedUserPF

The problem with this is that the decimals vary. Somne show 3 decimals, while
others shor 4 ot 5 decimals.
 
A

AuthorizedUserPF

There is no formulae. The numbers aparently came over from another
spreadsheet as values withb the decimals alreaddy there.
 
T

T. Valko

Ok, let's assume your numbers are in the range A2:A100. Enter this formula
in B2 and copy down as needed:

=INT(A2)
 
A

AuthorizedUserPF

Thanks that works. Can we add anything to it that would round up at >= .5
and down at <= .4
 
T

T. Valko

Use the round function...

=ROUND(A1,n)

Where n is the number of decimal places to round to.

A1 = 49.537

=ROUND(A1,2) = 49.54
=ROUND(A1,1) = 49.5
=ROUND(A1,0) = 50
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top