Hi all

I have created a dropdown box which shows names and a dollar value which is drawn from cells elsewhere with a long winded formula, my problem is that while all the names align to the left of the dropdown box all the dollar values are all over the place because of all the different lengths of the names, what I want to happen is when I choose a player (name) the name should appear in the cell aligning to the left and the Dollar value of that player should align to the right of the cell, I have tried highlighting the column - right clicking - format cell then choosing the alignment tab - in Horizontal choose Distributed (indent) that aligns all the dollar values to the right but then the names have moved, I am at a loss as to how to fix it.

I look forward to any replies
if you need to know anything else please just ask


Mike

Excel I am using is 2007