cell format round and display 2 decimal places

Question

I have one cell formatted as Number and with 2 decimal places.

The actual number is 69.30217 so in my cell, imagine cell A1, it appears like 69.30. This is OK.

With that cell, I'm making some concatenations so if I do something like this:

"&E5&"

The number appears as 69.30217. But if I do this:

"&ROUND(E5;2)&"

The number appears as 69.3.

What can I do to display that zero? What to show 69.30

Answer 1

Another way is to use FIXED function, you can specify the number of decimal places but it defaults to 2 if the places aren't specified, i.e.

=FIXED(E5,2)

or just

=FIXED(E5)

Answer 2

Use this

&TEXT(E5;"0.00")&

Answer 3

Input: 0 0.1 1000

=FIXED(E5,2)

Output: 0.00 0.10 1,000.00

=TEXT(E5,"0.00")

Output: 0.00 0.10 1000.00

Note: As you can see FIXED add a coma after a thousand, where TEXT does not.