Formula formatting

[Guest]

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!!

 

[Bob Phillips]

MIN($B9:$IV9)&"to "&MAX($B9:$IV9)

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

 

[Trevor Shuttleworth]

=TEXT(MIN($B9:$IV9),"0")&" to "&TEXT(MAX($B9:$IV9),"0")

or, more sophisticated:

=TEXT(MIN($B9:$IV9),"#,##0.00")&" to "&TEXT(MAX($B9:$IV9),"#,##0.00")

Regards

Trevor

 

[Guest]

thank you for your help!!! One other question:

Is there a way to have a workbook cell enter the current month based on the
current month from the system date? I don't need complete date, just month.

Thanks!

 

[Guest]

thanks for your help!!!

=TEXT(MIN($B9:$IV9),"0")&" to "&TEXT(MAX($B9:$IV9),"0")

or, more sophisticated:

=TEXT(MIN($B9:$IV9),"#,##0.00")&" to "&TEXT(MAX($B9:$IV9),"#,##0.00")

Regards

Trevor

 

[Dave Peterson]

=text(today(),"mmmm")
will spell out the month.

=month(today())
will give 1 to 12

 

[Guest]

Thanks!!!

=text(today(),"mmmm")
will spell out the month.

=month(today())
will give 1 to 12

 

[Rick Rothstein \(MVP - VB\)]

=text(today(),"mmmm")

Thanks!!!

For completeness sake,

=TEXT(TODAY(),"mmm")

will give you the 3-letter abbreviated month name.

Rick