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