Format numbers so they align

G

Guest

In a column how do I format so all numbers align using dollar signs? For
example,

$225
$1,035
$850
$1,125
$850

I am not able to figure out how to align the numbers so they flow through
the column in the following manner:

$ 255
$1,035
$ 25
$2,225
 
G

Guest

Use one of the accounting style formats and verify that the cells are not set
to left alignment.
 
G

Guest

$?,??0
or
$* #,##0

insert one of these as a custom number format. The first will put a space
of four digits wether it is fill or not (similar to what you want). The
second will align the $ to the left and the number to the right.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top