How to stop Excel from rounding up

U

Ulalume

Version: 2008 Operating System: Mac OS X 10.5 (Leopard) Processor: Intel Can someone help me figure out how to stop excel from rounding up the numbers I enter into the cells?
 
J

John McGhie

You need to format the cells to show sufficient numbers of Decimal places.

Select the cells, then choose Format>Cell>Number... And choose the number of
decimal places you want to see.

Cheers

Version: 2008 Operating System: Mac OS X 10.5 (Leopard) Processor: Intel Can
someone help me figure out how to stop excel from rounding up the numbers I
enter into the cells?

This email is my business email -- Please do not email me about forum
matters unless you intend to pay!
 
R

Robert Peirce

CyberTaz said:
Another possibility...

Check Excel> Preferences> Edit to make sure you don't have the box checked
for "Display this number of decimal places". It will have a similar effect
on the appearance but actually affects the values.

HTH |:>)
Bob Jones
[MVP] Office:Mac

That won't stop rounding. It will just change the number of significant
digits. You need to take the integer value INT().
 

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