Hello, I am trying to do something for work where I need text and a
formula in the same cell, and I have a formula that works, see below:

"at the rate of $"&('[RATE.xls]Rate1'!$L$954)&" per Hour"

But the problem is if the value the formula is pulling in is something
like $34.10 per hour, (where the second decimal digit is a zero) the
result shows:

at the rate of $34.1 per Hour

I don’t want it to show $34.1 as the value, I need it to show $34.10, I
need that zero on the end.

I have spent an hour trying to make it work to no avail, does anyone
have any suggestions? Is there a FORMAT function I can stick on
there?

Thanks a bunch!!!


--
caliskier
------------------------------------------------------------------------
caliskier's Profile: http://www.excelforum.com/member.php...o&userid=25887
View this thread: http://www.excelforum.com/showthread...hreadid=392747