View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Sloth
 
Posts: n/a
Default Format numbers so they align

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

"lance559" wrote:

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