end zero in a cell

  • Thread starter Thread starter mark64
  • Start date Start date
M

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.
 
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
 
Yes, it did help. Thanks very much.

Pete_UK said:
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
Click to expand...
 
Back
Top