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


.