i have a wrkbk that i'm trying to do a lookup using a column of cells that have number values. the values are visually left aligned (not formated that way). if i place my cursor in the formula bar and hit ENTER, the lookup works and the # becomes visually right aligned but nothing in formatting is different. WHAT IS GOING ON!??