Eliminate Decimals

[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

 

[joeu2004]

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.

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.

 

[GS]

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

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

 

[magmike]

Thanks Gary.

 

[GS]

Thanks Gary.

Glad to help...

--
Garry

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