Forcing 2 decimal points to value added to text string

Hi All

I have the following formula for displaying some text along with the rate at which we pay it:

CONCATENATE("Lodging Allowance @ £",Rates!C26)

The value itself is on the 'Rates' sheet and it finds it ok but it displays the result as:

Lodging Allowance @ £29.6

...I would have liked the extra '0' at the end, i.e.

Lodging Allowance @ £29.60

The value on the Rates sheet is indeed stored as 29.6 not 29.60 so I guess this is why it's happening.

Any thoughts on how I can force the prices to be displayed correctly with 2 decimal points in the text string?

Many thanks

Brelin

Try this

=CONCATENATE("Lodging Allowance @ £",TEXT(Rates!C26,"0.00"))

Hope this helps