|Posted by:||Jan Kronsell (kronsell(removebeforesend)@adslhome.dk)|
|Date:||Fri, 14 May 2004|
I use this formula
I the first column in the matrix i have fx '345 that is the number as a
textstring. In the lookup cell (A1) i have 34567 and everything works ok.
But if in the matrix I have '002 and in the lookup cell '002222 I get at
N/A. Even if the number in the cells are typed as text, it is treated as
numbers. I can see that VALUE(LEFT(A1,3) returns 2, not 002 as expected. Is
the anyway to solve this?