end zero in a cell
 

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.

end zero in a cell
 

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

On Sep 12, 1:33*am, mark64 wrote:
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.

end zero in a cell
 

Yes, it did help. Thanks very much.

"Pete_UK" wrote:

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

On Sep 12, 1:33 am, mark64 wrote:
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.

end zero in a cell
 

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

Pete

On Sep 12, 2:28*am, mark64 wrote:
Yes, it did help. *Thanks very much.



"Pete_UK" wrote:
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

On Sep 12, 1:33 am, mark64 wrote:
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.- Hide quoted text -

- Show quoted text -