Format the cells to align right:

=CONCATENATE("$",TEXT(ROUND('G:\AOMBudget\Daily RFSR\DAILY RFSR
FY06.xls'!auth.1fm/1000000,1),"#.0"))&"M"

Biff

"Jan Buckley" wrote in message
...
I'm using the following formula on a spredsheet:

CONCATENATE("$",ROUND('G:\AOMBudget\Daily RFSR\DAILY RFSR
FY06.xls'!auth.1fm/1000000,1))&"M"

A variation of this formula is used on other rows and I would the amounts
to
line up in a column and all have one decimal, even if it is zero. For
instance, the result of the above formula when rounded to 1 digit is $46M;
rounded to 2 digits it is $45.97M, etc. I want it to say $46.0M. I guess
what I'm trying to say is, I want all the numbers to line up to the left
of
the decimal and have only one number to the right of the decimal, even if
it
is zero. Can anyone make it happen? Thanks.