hi,
i have following problem.

i sort data with sverweis.

the search criteira look like this:

00.02.1
00.02.2222
00.02.2
00.02.3
....
...
00.02.9
00.02.9
00.02.10
00.02.10
...
00.02.14
00.02.15
...
00.02.19
00.02.20
00.02.20




and here is the problem:

in the row 00.02.20 sverweis read the data (another sheet) from 00.02.2
instead of 00.02.20

as it seems to ignore the ending "0" !!!


how can i format the source (00.02.20) to be readable for sverweis?

thanx for any idea, i took me already an hour to find out, why it does not work so far.

thanx
stan