| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 - |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Code to copy the formulae of one cell to all the cell in the rangewith the specific cell and columnnumber changing Options | Excel Discussion (Misc queries) | |||
| Code to copy the formulae of one cell to all the cell in the rangewith the specific cell and columnnumber changing | Excel Discussion (Misc queries) | |||
| Populate a cell if values in cell 1 and cell 2 match cell 3 and 4 | Excel Worksheet Functions | |||
| cell data not validated if navigating cell to cell with mouse | Excel Worksheet Functions | |||
| How to create/run "cell A equals Cell B put Cell C info in Cell D | Excel Discussion (Misc queries) | |||
Linear Mode
