Can I stop rounding in excel?

G

Guest

I am doing come calculations and end up with 139.7 for example. If I format
the cell as a number with no decmial points it automatically rounds up to
140. Normally this is ok, but in this case I don't wnat it to round. Can I
turn the rounding feature off?
 
G

Guest

Jmadden said:
I am doing come calculations and end up with 139.7 for example. If I format
the cell as a number with no decmial points it automatically rounds up to
140. Normally this is ok, but in this case I don't wnat it to round. Can I
turn the rounding feature off?

If you format the cell as "general" rather than using a specific number
format I believe you'll get what you want.

Enter PI() into a cell for example, and play with the various formatting
options. Right click on the cell and choose "Format Cells" and then the
"Number" tab. As you select the various format options you'll see the
effect in the little "sample" box.

Bill
 
G

Guest

Bill Martin -- (Remove NOSPAM from addre said:
If you format the cell as "general" rather than using a specific number
format I believe you'll get what you want.

Enter PI() into a cell for example, and play with the various formatting
options. Right click on the cell and choose "Format Cells" and then the
"Number" tab. As you select the various format options you'll see the
effect in the little "sample" box.

Bill



Thanks Bill,

after doing some more searching in the help data, I found the "int"
function. This gives you only the integer portion of a calculation. for
example "=int(a1/a2)" will give you 139, where simply a1/a2 gives you 139.75
which will round up if you remove the number of decmial positions.

Thanks again for you suggestions....
 
A

Arvi Laanemets

Hi

This isn't rounding. Unless you have turned 'Precision as displayed' feature
on, cell formatting doesn't affect stored value at all. Formatting only
changes the way, your data are displayed. Example:

Enter 1.5432 into cell A1. Format the cell A1 as Numeric with 0 decimals -
the number 2 is displayed. Format the cell A1 as numeric with 4 decimals -
1.5432 is displayed. Format cell A1 as numeric with 0 decimals again. Into
B1 enter the formula
=2*A1
and format as numeric with 4 decimals - not 4.0000 but 3.0864 is displayed.
Etc.
 
M

Myrna Larson

Do you mean that you want it to show 139 in this case? Or 139.7? If you don't
want it to round, you shouldn't set a format with a specific number of decimal
places.
 

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