Number decimal place

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

James8309 - 28 May 2008 08:21 GMT

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.

Reply to this Message

Nick - 28 May 2008 09:20 GMT

> Hey guys
>
[quoted text clipped - 13 lines]
>
> thank you everyone.

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

Reply to this Message

muddan madhu - 28 May 2008 11:08 GMT

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

> > Hey guys
>
[quoted text clipped - 18 lines]
>
> - Show quoted text -

Reply to this Message

joeu2004 - 28 May 2008 12:01 GMT

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

Reply to this Message