| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel insists on adding character to formula
Have a formula
What I would like: ,IF(COUNTIF(A1,"*"&{.124}&"*"),"yes" Excel "insists on placing a zero" before the dot in front of the 124 What it changes to by pressing enter: ,IF(COUNTIF(A1,"*"&{0.124}&"*"),"yes" I need the dot in the formula as to only check if the "124" immediately follows the dot, and not a 124 which may occur someplace within the cells contents. If I leave the zero in the formula, if does not return the correct answer. Is there a way around this apparent quirk? Thank you. pierre |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| adding up a particular character in a row | Excel Discussion (Misc queries) | |||
| Adding a character to a defined name with a formula or macro | Excel Discussion (Misc queries) | |||
| Excel 2000 insists on typing a formula | Excel Discussion (Misc queries) | |||
| Adding overscore to character in a cell in an Excell spreadsheet | Excel Discussion (Misc queries) | |||
| Adding a character to the beginning and end of txt in a cell | Excel Worksheet Functions | |||
Threaded Mode
