C
Carl Navarro
I have a table that has the car number, the driver's name, the finish
and the points awarded. Everything works fine, EXCEPT....
There are 3 cars with 2 digit numbers beginning wth 0x. I solved the
problem by using .01, .07 and .09, but I'd like something more
elegant. I can enter number 01, but VLOOKUP returns the result from
ZER0 and the array sort puts the 3 cars last. I also tried letter Ox
with the same result or, perhaps, another error.
Anybody got ideas? NASCAR sort by car works, listing 01 after 0 and
07 after 7.
Uh oh, Maybe it's in the fact that they use # in fromt of each number
Carl Navarro
and the points awarded. Everything works fine, EXCEPT....
There are 3 cars with 2 digit numbers beginning wth 0x. I solved the
problem by using .01, .07 and .09, but I'd like something more
elegant. I can enter number 01, but VLOOKUP returns the result from
ZER0 and the array sort puts the 3 cars last. I also tried letter Ox
with the same result or, perhaps, another error.
Anybody got ideas? NASCAR sort by car works, listing 01 after 0 and
07 after 7.
Uh oh, Maybe it's in the fact that they use # in fromt of each number
Carl Navarro