I have a question concerning formatting a cell to not show trailing zero's or leading zero's. For instance if I have the following numbers: 8, 1.62, .42 I want them listed as shown. The 8 should not have a decimal, the 1.62 is fine, and the .42 should not have a leading 0. How can I do this? I have tried multiple ways including the following: [=0]0;[>1]0;#.### which works for whole number and the number 0 and number lest then 1 but not for partial numbers greater than 1 such as the above example for 1.62. For the number 1.62 it would round it up to 2.