Align under decimal point

[Gary Coles]

How do I line up entries in cell columns under the decimal point ?
Thanks

 

[Gord Dibben]

Gary

Format>Cells>Number>Accounting

Gord Dibben Excel MVP

 

[Gary Coles]

I tried that already, thanks, but then the column aligns only to the right.
In " MS Works" I had the option of aligning the decimal points anywhere in
the column, my preference is to centre align the decimal points.
Thanks again

 

[Gord Dibben]

Gary

Format>Alignment>Horizontal>Right(Indent). Spin Button in a number like 5 or
6 or whatever fits.

Note: all cells must be formatted with same number of decimal points.

Gord Dibben Excel MVP

 

[Debra Dalgleish]

Another option is to use a custom number format:

Select the cells, or columns
Choose Format>Cells
On the Number tab, select the Custom category
In the text box, type: ????.????
(use can change the number of question marks)
Click OK

 

[BrianB]

Use format cells/number/custom formats with query marks
eg ??.??