Underline with accounting format

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Will Fleenor - 21 Sep 2006 17:01 GMT

Preface: If you use the accounting format and the underline you get a great
underline that is just a little less than the width of the cell.

Problem: It does not underline the right parenthesis in negative numbers.

Question: Is there any way to create a customized version of the accounting
format that will to go all the way to the right and go under the right
parenthesis for negative numbers?

Products: Windows XP with SP2 and Excel 2003 with all patches and updates
installed.

Thanks, Will

Reply to this Message

Susan - 21 Sep 2006 17:36 GMT

why not underline the CELL, not the text/numeric?
format, cells, borders, double underline
(somebody may have a better idea, tho!)

susan

Reply to this Message

Dave F - 21 Sep 2006 19:18 GMT

Yeah that's the way to do it. Apply the appropriate border from the
formatting toolbar

Signature

Brevity is the soul of wit.

> why not underline the CELL, not the text/numeric?
> format, cells, borders, double underline
> (somebody may have a better idea, tho!)
> :D
> susan

Reply to this Message

Will Fleenor - 21 Sep 2006 19:59 GMT

The problem with a border is that it connects to borders in adjoining cells.

> Yeah that's the way to do it. Apply the appropriate border from the
> formatting toolbar
[quoted text clipped - 4 lines]
>> :D
>> susan

Reply to this Message

Peter T - 21 Sep 2006 23:27 GMT

I guess you are using 'Double Accounting' underline. Would ordinary Double
underline work better.

Regards,
Peter T

> Preface: If you use the accounting format and the underline you get a great
> underline that is just a little less than the width of the cell.
[quoted text clipped - 9 lines]
>
> Thanks, Will

Reply to this Message

Rate this thread: