I want to use the “Round” function to 2 decimal places, but include any redundant zeroes after the decimal place.
Example: Round(A2,2) gives me 19.2, when l really want 19.20
To make matters worse, this is to be part of a Concatenate statement, so l cannot just format the cell. It all needs to be done via the formula itself.
Is this possible?