I'm using a round function within a concatenate function. I am rounding to 2 decimal places, but if the result has trailing zeroes, the round function will delete them. I'd like for it to always display two decimal places.
For example, if I have numbers 2.999 and 4.354 and I want a cell that displays "3.00-4.35" so I use the formula
=concatenate(round(2.999,2),"-",round(4.354,2))
But this displays "3-4.35" instead.
I can't use the "Format Cells" option, because the cell is no longer in number format. Trying a "custom" format like "#.##-#.##" does not work. I also tried the "Set Precision as Displayed" option, but it did nothing.
Is there any way I can force Excel to display the trailing zeroes when my numbers are calculated by functions?
Thanks!
Bookmarks