I'm having trouble making a weekly report sheet. I want to format the cells
such that if the number that appears is a fraction it only appears to one
decimal place AND if it is a whole number the decimal point is not shown.
i.e. 1.234 appears as 1.2, 12 appears as 12, not 12.0

And, secondly it there a way of aligning contents of cells to the decimal
point even if they have different degrees of accuracy (i.e to 1 or more such
that a cell containing 12 would align with 1.2 as:
12
1.2

Thanks