With values in A1 to A100:

=Max(A1:A100)

OR

=Large(A1:A100,1)

--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"chunky" wrote in message
...
trying to create a cell that will choose the greatest number out of a
column
of entries