Hi,
I am looking to format a column of numbers - this should be easy -
If the equation = 0 I want to print a blank
If the equation = number I want to have 1 decimal place
I have tried the easy ##.# but it of course prints the decimal point.
Of course "##.#" prints a decimal point but you say you want 1 decimal place - how do you expect it to show?
Enjoy,
Tony
-------------------------------------------------------------------------------------------- We want to help you; help us to do it by reading this: Before you ask a question.
Another way is to simply format your cell to display one decimal place, and then go to Tools/Options/View and un-check the "Zero Values" checkbox. That way, any zeroes on your sheet will be displayed as blanks.
HTH,
Andy.
-------
I am not responsible for any "Sponsored Links" which may appear in my messages.
asrisk has the simplest and best answer, but if the cells are calculated remember to round the answer (=round). Otherwise you could end up with a minute fraction, eg 0.00000001234, which is too small to be significant but still makes the result technically non-zero. The display will then show 0.0, in line with the formatting, and you'll wonder why when it's set not to display zeros!
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.