Round function in another formula? Simple?

Hey everyone,

trying to figure out something here. I have a list of numbers that I would like to keep in decimals to the hundreths. I have achieved this by using the round function. I am now trying to use that value inside another formula but the result does not retain the decimal places. Even if the item value is 12.00, I would like for it to show up in the text formula as 12.00 but it only shows 12. While this works for any number with a value other than zero in the decimal places, it doesn't retain the decimals when they are zeros. Could anyone help me on how I can achieve this?

CELL A1: 37
CELL B1: =round(a1,2) result: 37.00
CELL C1: ="my height is "&b1 result: my height is 37

I would like the decimal places to show in the result.

You can use this:

="my height is "&TEXT(b1,"0.00")

to ensure 2 decimal places.

Hope this helps.

Pete