Number format than does not display zeros after the deciaml point

N

Nic

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel does not accept text format! 0
Varying format 2
yearfrac format error? 4
Formatting zeros as dashes 4
Custom number format #,##0.## yields extra '.' when formattingintegers 3
Zeros after the decimal 7
Number Format not lining up 5
number format? 4

Top