Is there any way to do this:
I have cell and most of the numbers have 2 significant digits like
3.45. But once in a while I have a number like
143 big number, the rest are under
10. Currently for
143 the cell is displaying
143.00 which takes up too much space. I want it to show
143 just three digits. Is there a way to format it so it only shows 3 digits? no matter where the decimal point is?