Ratio Format

[Kathleen_0422]

Good Morning All, I am trying to show a ratio by adding the ":1" to the following formula, problem is it is returning a value of

<TABLE style="WIDTH: 41pt; BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=0 width=54 border=0 x:str><COLGROUP><COL style="WIDTH: 41pt; mso-width-source: userset; mso-width-alt: 1974" width=54><TBODY><TR style="HEIGHT: 15.75pt; mso-height-source: userset" height=21><TD class=xl24 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; WIDTH: 41pt; BORDER-BOTTOM: #d4d0c8; HEIGHT: 15.75pt; BACKGROUND-COLOR: transparent" width=54 height=21>2.09271523178808:1</TD></TR></TBODY></TABLE>

=CONCATENATE(VALUE((T6+U6)/V6))&":1"


How can I force the formula to produce a #.00 Format as opposed to the results that are being returned?

Thanks I appreciate any guidance you can provide

 

[mikerickson]

What result do you want?

 

[Andrew Poulsom]

Try:

=CONCATENATE(TEXT((T6+U6)/V6,"#.00")&":1")

 

[Kathleen_0422]

Thank you so much I was trying to add FormatNumber and kept getting a # something. Your formula worked perfectly!