Decimal format

  • Thread starter Thread starter Herb
  • Start date Start date
H

Herb

Is there a way to decimally align numbers that are centered in a column
without adding zeros?

3452.0
.2
21.02

I know it seems weird, but that's what client wants.
 
Try this:

From the menu, Format > Cells, then in Custom type:
#,##0.0???_-;#,##0.0???_-
 
Back
Top