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

--
Biff
Microsoft Excel MVP


"AuthorizedUserPF" wrote in
message ...
Thanks that works. Can we add anything to it that would round up at = .5
and down at <= .4

"T. Valko" wrote:

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

=INT(A2)

--
Biff
Microsoft Excel MVP


"AuthorizedUserPF" wrote in
message ...
There is no formulae. The numbers aparently came over from another
spreadsheet as values withb the decimals alreaddy there.

"T. Valko" wrote:

Did you try my suggestion?

--
Biff
Microsoft Excel MVP


"AuthorizedUserPF" wrote
in
message ...
The problem with this is that the decimals vary. Somne show 3
decimals,
while
others shor 4 ot 5 decimals.

"Nadine" wrote:

Forgot...use Ctrl+Enter after typing the formula.

"Nadine" wrote:

You could try =DOLLAR(cell,#) where #=number of decimals.

"T. Valko" wrote:

the decimals are be calculated

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

=INT(your_formula_here)

--
Biff
Microsoft Excel MVP


"AuthorizedUserPF"
wrote
in
message
...
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


.



.



.