Forum Discussion
Limiting number of decimal places in a returned formula
I have an Ex 2010 formula that returns 4 decimal places (.7501). I need to use only the first 2 decimal places (.75) for another calculation. I have tried roundup, and although the cell only display...
If to display you may use
="DELTA H: " & TEXT( SQRT(((C764-C29)^2)+((D764-D29)^2)), "#.###")
SergeiBaklan Awesome! It worked! One more question... when I inserted that formula into the cell it is not showing the leading 0 in the final result. For example the cell shows:
DELTA H: .056
Is it possible to show as:
DELTA H: 0.056
That could be 0.### as string for the format. You may google for custom number formats for more details.