Try this array formula** :

=INDEX(A6:AA6,MATCH(TRUE,ISNUMBER(A6:AA6),0))

** array formulas need to be entered using the key combination of
CTRL,SHIFT,ENTER (not just ENTER). Hold down both the CTRL key and the SHIFT
key then hit ENTER.

--
Biff
Microsoft Excel MVP


"sandy" wrote in message
...
Hi!
how can i make this formula to return the leftmost number only?

this is an array formula
=INDEX(A6:AA6,,MIN(IF(A6:AA6<"",COLUMN(A6:AA6))))

Thanks!