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