I want to use the "ROUND" function in my formula and limit the outcome to 2 decimals, but I also want it to always force to 2 decimals. Right now when the last digit is "0", it just leaves it off.
I am using it like this... =ROUND(formula),2) & " Text"
It displays the 2 decimals if I leave the "text" off, but only displays 1 decimal when last is "0" with the "text" added.
Thanks.
I am using it like this... =ROUND(formula),2) & " Text"
It displays the 2 decimals if I leave the "text" off, but only displays 1 decimal when last is "0" with the "text" added.
Thanks.