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. – Seth May 26 '17 at 10:15