alignment

  • Thread starter Thread starter Guest
  • Start date Start date
G

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

Forgetmenot said:
Can someone tell me how you align numbers around the decimal point in a
Click to expand...
column using the Microsoft Excel program? Thank you in advance.
 
Try Custom Formatting <Accounting>
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
Forgetmenot said:
Can someone tell me how you align numbers around the decimal point in a
Click to expand...
column using the Microsoft Excel program? Thank you in advance.
 
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.
 
Back
Top