On Wed, 05 Apr 2017 17:20:35 +0800, pedro wrote:

On Tue, 4 Apr 2017 08:51:21 -0700 (PDT), "F.G."
wrote:

Hi all,

How do I ask Excel to stop "rounding"?

I know Round up and down functions however I want excel to stop "rounding" and do not take into account the decimals.

Example:
whether the result is $1,375.35 or $1,375.85 I want excel ignore the decimals and to show $1,375 and not "round" to $1,375 or $1,376.

Check out the INT() function.

INT may produce undesired results for negative numbers:
int(-1375.35) = -1376