# Calc: Is it possible to display the same number of decimal places as formulae input cells

For example, I'm subtracting a series of pairs of numbers in one column from another and displaying the result in a third. Some of these number pairs are five digits to one decimal place (e.g 17382.1) and others are less than 1 but to 5 decimal places (e.g 0.85467)

At the moment I have to set the cell format to 5 decimal places for the multi decimal place numbers to display correctly and this has the effect of displaying ALL the results to 5 places even when they are whole numbers - e.g 25324 is displayed as 25234.00000 and so on. This makes the column an unnecessary 10 digits wide with the redundant zeroes making the numbers messy and less easy to read.

Is there a way to: A) display only the number of decimal places as in the input cells? B) Limit the the total number of displayed digits to 6? C) Somehow reduce the column width to 6 digits wide without getting the hashes instead of a number?

As a beginner, any relatively polite suggestions will be most welcome.

Many thanks in advance

Shouldn't the 'General' number format do it just the way you want? In what way does it not meet your aspirations?

By the way: I cannot admit your statement the..

"redundant zeroes making the numbers messy and less easy to read". To the contrary I would expect numbers in one column to be aligned with resptect to the decimal separator.Whether or not the trailing zeros are significantor may simulate an accuracy not actually achieved, is another question.Thanks very much for your input Monsieur and you are, of course, absolutely right about the General format. I omitted to mention that I want to display a decimal point followed by a zero for the whole numbers, which I wasn't getting. Senor Kaganski (below) has provided with me the perfect answer for me in using "hashes" to replace the zeroes where I'd want them displayed. I do appreciate your prompt answer though.