User Profile
Victor207
Copper Contributor
Joined 5 years ago
User Widgets
Recent Discussions
Re: Limiting number of decimal places in a returned formula
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.056176KViews0likes1CommentRe: Limiting number of decimal places in a returned formula
Jihad Al-Jarady I have a similar problem where I have a square root formula that has text and the answer in the cell. I would like to limit the decimal places in the final answer to 3 places. This is my formula: ="DELTA H: "&SQRT(((C764-C29)^2)+((D764-D29)^2)) For example, the answer comes out as: DELTA H: 0.0564003545403856 And I would much rather have the answer display as: DELTA H: 0.056185KViews0likes4Comments
Recent Blog Articles
No content to show