Excel Rounding Issue

[asmall]

How can I stop Excel from rounding decimals up or down?

 

[dyarwood]

use the INT function. This should give you just the integer part of the number.

 

[Molby]

Format the cells as Number and set the amount of decimal places you want.

 

[SkipVought]

asmall,

Please keep in mind that cell FORMATTING does not change the VALUE in the cell -- it just changes how it LOOKS.

If you want a value ROUNDED to a specified number of digits, you actually need to CHANGE THE VALUE.

Skip,

http://www.TheOfficeExperts.com

Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884

 

[asmall]

I don't want just the integer part to be shown.
For instance, I'm doing accounting spreadsheets and if i have a value of 1,754.987. I don't want Excel to round it to 1,754.99. I want the value to be 1,754.98.

 

[SkipVought]

=INT(A1*100)/100

where A1 contains 1754.987



Skip,

http://www.TheOfficeExperts.com

Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884

 

[DrBowes]

=INT(100*A1)/100 should do it. (For a value in A1 of course.)

 

[DrBowes]

D'oh - A second earlier and it would have looked like Skip had copied me!!!

 

[SkipVought]

{funny, says I to Me. Me thinks thet Dr B has COPIED me fermuler, the cheatin *%#&^!!!)



Skip,

http://www.TheOfficeExperts.com

Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884

 

[DrBowes]

I was so sure I would get away with it....

 

[buitenhek]

=ROUNDDOWN(A1,2)where A1 is your value.

Regards
Peter Buitenhek
Profit Developer.com