Eliminate Decimals

  • Thread starter Thread starter magmike
  • Start date Start date
M

magmike

How would I make this: SUM(L3:L19) not show decimals in the results. I want to see the decimals in the reference cells, but not the formulas results.

Thanks in advance for your help,
magmike
 
magmike said:
How would I make this: SUM(L3:L19) not show decimals in the
results. I want to see the decimals in the reference cells,
but not the formulas results.
Click to expand...

I think you are saying you want the calculation to preserve the exact value
(with decimal fraction), but you want the cell to display the rounded
integer.

Just change the cell format to Number with zero decimal places. Right-click
on the cell(s), click on Format Cells, the Number tab, Number and enter zero
into the Decimal Places field.
 
How would I make this: SUM(L3:L19) not show decimals in the results. I want
to see the decimals in the reference cells, but not the formulas results.

Thanks in advance for your help,
magmike
Click to expand...

Perhaps...
=ROUND(SUM(L3:L19),0)

--
Garry

Free uenet access at http://www.eternal-september.org
Classic VB Users Regroup
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion
 
Back
Top