Trivial Excel Problem

[sliderule]

This will seem trivial to most of you, but I'm a style/appearance freak with regard to documents. Having barred my soul, here's my problem. I have a column of numbers, some in the six digit range and some mere single digits. I want the underscore of the bottom number (in the cell above the sum) to be as wide as the largest number in the column - purely for looks. If the bottom number is, say, a single digit, Excel just puts an underscore under that single digit and it ain't purdy. Any advice will be appreciated.

 

[jbcalg]

try putting the top border line in the sum cell instead of the one above it
although it sounds like you're using the underline feature - because a bottom border line in the last number cell (the one above the sum) should work equally as well

 

[XL Guru]

>> If the bottom number is ... a single digit, Excel
>> just puts an underscore under that

I believe that's pretty much how it works. jbcalg's "borderline" solution is recommended.

If you have "123456" in A1 and "789" in A2, you can turn font underline on for A2 and amend the content of the cell to

=" "&789

or something similar to kludge it (that's mutiple spaces, it just doesn't show up that way in here). But then =SUM(A1:A2) falls over. You'd have to use =A1+A2 instead. So I wouldn't recommend that at all, probably.

Rgds,
Andy

 

[jbcalg]

>> .... jbcalg's "borderline" solution is recommended.

yup, borderline, that describes me and my solutions