Menu
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
726
On the Formulas tab, under Function, click Formula Builder. In number, type the number you are rounding up. In num_digits, type 0 to round the number up to the nearest whole number. In number, type the number you are rounding down.
Click the cell where you want your rounded result to go. Head to Formulas > Math & Trig, and then choose either the “ROUNDUP” or “ROUNDDOWN” function from the dropdown menu. Enter the number (or cell) you want to round in the “Number” field.
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)
137
Use this
&TEXT(E5;"0.00")&
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.
43
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
