Set fixed Decimal places with no rounding

  • Thread starter Thread starter azza
  • Start date Start date
A

azza

Hi.

Im trying to cut off the extra decimal places. i only want it to be 1dp or
2dp depending on the place. I used the LEFT function for the whole numbers,
and played with the =FIXED(A1,1) but this rounds the numbers.

Basically I want 90.789 to = '90.7'. 90.3985=90.3 90.333 = 90.3

The number is a result of a calculation.

Thanks.
 
Hi.

Im trying to cut off the extra decimal places.  i only want it to be 1dp or
2dp depending on the place. I used the LEFT function for the whole numbers,
and played with the =FIXED(A1,1) but this rounds the numbers.

Basically I want 90.789 to = '90.7'.      90.3985=90.3      90.333 = 90.3

The number is a result of a calculation.

Thanks.
Click to expand...

TRUNC( 90.789, 1) = 90.7
 
Fantastic.

Had tobe something simple. It does not seem to let me to different number of
dp though. ie 90.7898 = 90.78 even after changing the no of digits to 2....

Thanks.
 
"90.7898 = 90.78 even after changing the no of digits to 2"

Isn't that what you want?

Regards,
Fred.
 
Sweet.... Found the problem, there was formatting on the cell.. Changed it
back to General and it works. Thanks heaps.
 
Back
Top