alignment

[Guest]

Can someone tell me how you align numbers around the decimal point in a column using the Microsoft Excel program? Thank you in advance.

 

[Earl Kiosterud]

Not,

If you want to display a fixed number of digits to the right of the decimal
point, then use Format - Cells - Number - Number tab. Select how many
decimal places you want in the "decimal places" box.

If you have a variable number of right digits, like

1.2
100.2
1.23456

and want to display whatever right digits are there, then use Format -
Cells - Number - Custom, and a format code like
#.????
#,###.????
These codes are for four digits to the right.

In all cases, if the number has more right digits than the format code calls
for, the displayed number will be rounded to fit.

--
Earl Kiosterud
mvpearl omitthisword at verizon period net
-------------------------------------------

Can someone tell me how you align numbers around the decimal point in a

column using the Microsoft Excel program? Thank you in advance.

 

[Ragdyer]

Try Custom Formatting <Accounting>
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

Can someone tell me how you align numbers around the decimal point in a

column using the Microsoft Excel program? Thank you in advance.

 

[Lady Layla]

Format the cells as currency or accounting, with or without the , for thousands
seperator and with or without the $


: Can someone tell me how you align numbers around the decimal point in a column
using the Microsoft Excel program? Thank you in advance.