Eliminate Decimals

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
 
J

joeu2004

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.

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.
 
G

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
 

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