I am using the following formula to compare a range of cells for dates and to
return a high and low date in one cell.
=TEXT(MIN($B9:$IV9),"mm/dd/yy")&" to "&TEXT(MAX($B9:$IV9),"mm/dd/yy")

My question is this: what do I use in place of mm/dd/yy formatting if I
want to compare a range of cells for a high & low number and want the
information returned to be a number rather than date?

Where can I see a list of valid formatting options (i.e. %, text, date,
accounting, $$, etc..)

Thanks!!