cell buffer and lining dollar amounts up over the

  • Thread starter Thread starter John
  • Start date Start date
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
 
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.
 
Back
Top