My Excel spreadsheet is calculating some decimal values. Depending on the input value, the result may be e.g.
0
0.5
0.04166(6)
I would like these values to appear as
0
0.5
0.0417
that is limit the maximum number of decimal digits but not set the minimum one, allowing it to be 0 or more as needed.
With "general" format, I get the minimum required but unlimited number of digits, i.e. 0, 0.5, 0.0416667.
With "number" format, I get 0.0000 and 0.5000 if I want to get 0.0417.
Any way around? FWIW I am on Excel 2010.
ROUND
function and not use a specific format.