software

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,225Use one of the accounting style formats and verify that the cells are not set
to left alignment.
--
Kevin Backmannquot;lance559quot; wrote:

gt; In a column how do I format so all numbers align using dollar signs? For
gt; example,
gt;
gt; $225
gt; $1,035
gt; $850
gt; $1,125
gt; $850
gt;
gt; I am not able to figure out how to align the numbers so they flow through
gt; the column in the following manner:
gt;
gt; $ 255
gt; $1,035
gt; $ 25
gt; $2,225
gt;

$?,??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.

quot;lance559quot; wrote:

gt; In a column how do I format so all numbers align using dollar signs? For
gt; example,
gt;
gt; $225
gt; $1,035
gt; $850
gt; $1,125
gt; $850
gt;
gt; I am not able to figure out how to align the numbers so they flow through
gt; the column in the following manner:
gt;
gt; $ 255
gt; $1,035
gt; $ 25
gt; $2,225
gt;