Set fixed Decimal places with no rounding
 

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.

Set fixed Decimal places with no rounding
 

On Jul 3, 8:33*pm, azza wrote:
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.

TRUNC( 90.789, 1) = 90.7

Set fixed Decimal places with no rounding
 

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.

"recrit" wrote:

On Jul 3, 8:33 pm, azza wrote:
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.

TRUNC( 90.789, 1) = 90.7

Set fixed Decimal places with no rounding
 

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

Isn't that what you want?

Regards,
Fred.

"azza" wrote in message
...
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.

"recrit" wrote:

On Jul 3, 8:33 pm, azza wrote:
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.

TRUNC( 90.789, 1) = 90.7

Set fixed Decimal places with no rounding
 

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

"Fred Smith" wrote:

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

Isn't that what you want?

Regards,
Fred.

"azza" wrote in message
...
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.

"recrit" wrote:

On Jul 3, 8:33 pm, azza wrote:
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.

TRUNC( 90.789, 1) = 90.7