| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Two cells whose contents look alike but aren't
I have an what appears to be a five digit integer in cell "A1" which has a
very strange property. If I type the same five digits into cell "A2" and then in a cell "A3" type the function =if(Range("A1") = Range("A2"),"Yes","no") the result is "no". If I then double click cell "A1" (as if I wanted to edit) and hit the enter key, the function value magically changes to "yes". The strange integer was copied from the zip code field of an address file. Can anyone please tell me what's going on? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| concatenate contents of cells whose contents resemble cell referem | Excel Worksheet Functions | |||
| vlookup sound alike | New Users to Excel | |||
| Combining alike cells? | Excel Discussion (Misc queries) | |||
| Excel DB alike? | Excel Discussion (Misc queries) | |||
| copying cells with formulas, but to keep it alike in destination | Excel Programming | |||
Threaded Mode
