I have numbers in cells in Excel. I want the numbers formatted so that if they have decimal places they show to a maximum of two, and if they have no decimal places it doesn't show any.
- 15 should be formatted as 15, NOT 15.00
- 14.3453453 should be formatted as 14.35
- 12.1 should be formatted as 12.1
- 0 should be formatted as 0
The closest custom format code I've come up with is
0.##. Unfortunately this formats
15.00 as 15. (note the extra decimal point).
To further complicate the issue, the spreadsheet is a result of an export from SQL Server Reporting Services. So no macros are possible. Oh well, it looks like
0.## is my best bet, and they can just live with the extra period.