I have 2 columns to compare,each text. doing formulas, they don'.

I am trying to compare two columns of data with the match function. The
values are the same, but it seems as if the formatting is different because
the match doesn't find the matched data. I have chosen "format Cells" and
made sure both are a text format, but it doesn't seem to affect the format.
When doing the match, the first column displays as "1066", the second as
1066. Can someone help?

Some thoughts ..

Copy an empty cell and do a paste special > add > ok
to the entire range of text numbers to coerce these to real numbers

One other alternative would be to use something like
=MATCH(TEXT(A1,"0000"),...,0)

instead of
=MATCH(A1,...,0)

to convert the lookup values' real numbers (say)
to match with the reference column's text numbers (say)

--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <at>yahoo<dot>com
----
"Help with Match function & cell formats" <Help with Match function & cell
formats@discussions.microsoft.com> wrote in message
news:8778CD58-5F51-49B3-B92E-5C2A7C9DC58F@microsoft.com...
> I am trying to compare two columns of data with the match function. The
> values are the same, but it seems as if the formatting is different
because
> the match doesn't find the matched data. I have chosen "format Cells" and
> made sure both are a text format, but it doesn't seem to affect the
format.
> When doing the match, the first column displays as "1066", the second as
> 1066. Can someone help?
>