cell buffer and lining dollar amounts up over the

J

John

Is there a way to set text in from the sides of a cell? I've tried the left
indent but I want a right indent. Sort of a cell padding.

What I also want is to format a column so that dollar amounts to line up on
the decimal. Is there a way to get dollar amounts to line up vertically on
the decimal points?

Thank you,
John
 
J

J.E. McGimpsey

The basic number formatting codes are in Help (search for number
format). In this case:

0.??

will line your numbers up with two digits to the right of the
decimal.

You can add space using the _ character. It leaves enough space for
whatever follows it, so

0.??_)

will align numbers on the decimal point, and will add enough extra
space on the right for a right parenthesis.
 
Top