excel formula with format question 2

[mscallisto]

I thought I saw this in a thread long ago but can't seem to find it.

I need a formula like:

=A1/B1 NumberFormat"0.00" &' is the ratio'

where NumberFormat"0.00" is whatever it takes to set the format to numeric with 2 decimal places

and where " is the ratio" is a literal

the results could be 144.25 is the ratio

 

[venkman]

=concatenate(text((a1/b1), <Number Format>), &quot; is the ratio&quot

How's that?
-Venkman

 

[mikevh]

=TEXT(A1/B1,&quot;###0.00&quot&&quot; is the ratio&quot;

You might need to add some more &quot;#&quot; signs if you need
more digits to the left of the decimal.

 

[GlennUK]

You could also just have =A1/B1 in the cell, and change the number format, using menu command Format/Cells/Number/Custom
and type this as the format ...

#,##0.00&quot; is the ratio&quot;

and that will do what you want.

Glenn.

 

[mscallisto]

Thanks All

Exactly what I needed, both methods work, mikevh however did it in the fewest keystrokes!

 

[mikevh]

Thanks, mscallisto. I was so happy when I learned about &quot;&&quot; for concatenation in Excel. &quot;concatenate&quot; just seems way too long for convenience.

 

[venkman]

As I am so happy now to realize it.

 

[mscallisto]

Case closed!! Thanks again very much!