Decimal Places in a formula

[RhysGM]

Type 1.101 in A1

In A2 type round(A1,2)

The result is 1.1

I need the result to be 1.10

This is part of a longer formula with several of these occurances and I don't want to go down the route of finding the length and then adding a '0' if it's short. Does anyone know a better/easier way?

[sweep]

Hi,

Select the cells where you need two decimal places.

Do Format > Cells > Number > Number > demical Places > 2

[RhysGM]

Doesn't work.

round(A1,2) & " " & round(B1,1)

This is more like the formula I'm using. Also some may need to be to 1 decimal place and others to 2

[martindwilson]

=TEXT(ROUND(A1,2),"0.00")&" "&TEXT(ROUND(B1,1),"0.0")
perhaps

[RhysGM]

=TEXT(ROUND(A1,2),"0.00")&" "&TEXT(ROUND(B1,1),"0.0")
perhaps

Genius. Thanks