Formula to identify decimal versus whole numbers
Alternatively (and this may be a new feature), if you select "Automatic" under formatting it will achieve the same result.
Ask me how dumb I feel that I just found that out after trying all these formulas.
|