end zero in a cell

[mark64]

Can excel differentiate between the number 16.6 and 16.60 ? If so, how can I
give a value of TRUE in a cell when 16.60 is entered into the active cell but
FALSE if 16.6 is entered in the same active cell? (Or in an IF function,
etc.) Thanks.

 

[Pete_UK]

Excel can only distinguish between those two if they are entered as
Text values, i.e. type an apostrophe in front of them like so '16.60
and '16.6. The apostrophe will not show in the cell. If you put those
in A1 and B1, then this formula in C1:

=A1=B1

will return FALSE.

Hope this helps.

Pete

 

[mark64]

Yes, it did help. Thanks very much.

Excel can only distinguish between those two if they are entered as
Text values, i.e. type an apostrophe in front of them like so '16.60
and '16.6. The apostrophe will not show in the cell. If you put those
in A1 and B1, then this formula in C1:

=A1=B1

will return FALSE.

Hope this helps.

Pete

 

[Pete_UK]

You're welcome, Mark - thanks for feeding back.

Pete