![]() |
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 12:03 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com