Number decimal place

[James8309]

Hey guys

I have bunch of numbers in different decimals in column B and C

I try to compare whether value in cells next to each other are same or
not.

I am having problems with decimal points because

e.g. 1.90 doesn't return true with 1.901

I went to number format and changed to two decimal points and it still
doesn't work because value is still 1.901.

how do i permanently change decimal points?

thank you everyone.

 

[Nick]

Hey guys

I have bunch of numbers in different decimals in column B and C

I try to compare whether value in cells next to each other are same or
not.

I am having problems with decimal points because

e.g. 1.90 doesn't return true with 1.901

I went to number format and changed to two decimal points and it still
doesn't work because value is still 1.901.

how do i permanently change decimal points?

thank you everyone.

You could round the number using Excel's Round function. There even
seems to be roundup and rounddown functions.

 

[muddan madhu]

in C1 u have 1.901 , in D1 use =TRUNC(C1,2)

You could round the number using Excel's Round function. There even
seems to be roundup and rounddown functions.- Hide quoted text -

- Show quoted text -

 

[joeu2004]

I am having problems with decimal points because
e.g. 1.90 doesn't return true with 1.901
I went to number format and changed to two decimal
points and it still doesn't work because value is
still 1.901.

Right. Formatting only changes appearance, not the underlying value.

how do i permanently change decimal points?

Two ways: (a) explicitly round (or truncate) all relevant
computations, or at least round/truncate the operands of the
comparison; or (b) go to Tools / Options / Calculations and set
Precision As Displayed.

However, be wary of doing #b. If you have not been careful with cell
formats, you can end up permanently losing higher precision of some
constants.