Can I stop rounding in excel?

  • Thread starter Thread starter Guest
  • Start date Start date
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?
 
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?
Click to expand...

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
 
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
Click to expand...



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....
 
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.
 
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.
 
Back
Top