G
Gary Coles
How do I line up entries in cell columns under the decimal point ?
Thanks
Thanks
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
G
Gord Dibben
Gary
Format>Cells>Number>Accounting
Gord Dibben Excel MVP
Format>Cells>Number>Accounting
Gord Dibben Excel MVP
G
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
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
G
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
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
D
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
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
B
BrianB
Use format cells/number/custom formats with query marks
eg ??.??
eg ??.??