Adding trailing zeros to rounding formula containing text

[cisrael]

Hello. I am using the following formula: =$G$5&ROUND(F134/F25,2)& "/eqv.". I am wanting the output to show zeros in the hundredths place instead of being dropped by Excel's default function. Right now my output is "0.4/eqv." but I would like for it to be "0.40/eqv.". Is there any way I can do this? I am open to a new formula as well as long as my results are the same.

Thanks

 

[Fluff]

How about
=$G$5&TEXT(ROUND(F134/F25,2),"#0.00")& "/eqv."

 

[Tetra201]

Try

=$G$5&TEXT(F134/F25,"0.00")& "/eqv."

 

[Rick Rothstein]

Hello. I am using the following formula: =$G$5&ROUND(F134/F25,2)& "/eqv.". I am wanting the output to show zeros in the hundredths place instead of being dropped by Excel's default function. Right now my output is "0.4/eqv." but I would like for it to be "0.40/eqv.". Is there any way I can do this? I am open to a new formula as well as long as my results are the same.

I am not sure what is supposed to be in cell G5, but from your posting, it looks like the empty text string (""). Anyway, see if this does what you want...

=G$5$&TEXT(F134/F25,"0.00")&"/eqv"

 

[sandy666]

or
=$G$5&FIXED(ROUND(F134/F25,2),2)& "/eqv."

 

[cisrael]

How about
=$G$5&TEXT(ROUND(F134/F25,2),"#0.00")& "/eqv."

Perfect! Thank you very much for your help, I greatly appreciate it!

 

[cisrael]

Try

=$G$5&TEXT(F134/F25,"0.00")& "/eqv."

This one works as well. Thank you for taking the time to reply and help!

 

[cisrael]

I am not sure what is supposed to be in cell G5, but from your posting, it looks like the empty text string (""). Anyway, see if this does what you want...

=G$5$&TEXT(F134/F25,"0.00")&"/eqv"

Thank you, Mr. Rothstein! I really appreciate everyone's advice. You are correct it is an empty text string, I wanted to delete it but my President instructed me to leave it for some reason. Thank so much again for your help.

 

[cisrael]

Thank you very much, Sandy. I appreciate you taking the time to reply. This one worked great, too!

 

[Fluff]

Glad we could help & thanks for the feedback