Failed Comparison... why?
On Dec 5, 12:15 pm, Mark Lincoln wrote:
You mentioned that both cells in question are formatted as Text, but
when I have two absolutely identical numbers that don't evaluate as
being equal it's always a case one cell formatted as Text versus one
that is not. Does the database import manage to change the formatting
of that cell? Or is Excel somehow treating it as a number regardless
of the formatting?
I thought that might be it so I formatted them both as text. It seemed
to work because the alignment immediately changed. But they still did
not evaluate as equal.
Thanks,
S.
|