Excel: Return number within text to two decimal places
Posted on 2014-04-13
I have the following formula in an excel cell:
="Test text $"&(C10-D10)&" test text"
I would like the value in the middle to return as two decimal places. Currently it only returns as 1 decimal place.
e.g: Test text $32.4 test text
But I want: Test text $32.40 test text
How do I edit the formula so it returns two decimal places?
Thanks for your help