Number decimal place

  • Thread starter Thread starter James8309
  • Start date Start date
J

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.
 
James8309 said:
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.
Click to expand...

You could round the number using Excel's Round function. There even
seems to be roundup and rounddown functions.
 
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 -
Click to expand...
 
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.
Click to expand...

Right. Formatting only changes appearance, not the underlying value.
how do i permanently change decimal points?
Click to expand...

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.
 
Back
Top