Decimal format

[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.

 

[Andy Wiggins]

Try this:

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

 

[Herb]

Worked like a charm. Thanks you genius.

Try this:

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

--
Andy Wiggins FCCA
www.BygSoftware.com
Excel, Access and VBA Consultancy
-