ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Number format than does not display zeros after the deciaml point (https://www.excelbanter.com/excel-discussion-misc-queries/119471-number-format-than-does-not-display-zeros-after-deciaml-point.html)

Nic

Number format than does not display zeros after the deciaml point
 
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



All times are GMT +1. The time now is 04:58 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com