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