ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Underline with accounting format (https://www.excelbanter.com/excel-worksheet-functions/111024-underline-accounting-format.html)

Will Fleenor

Underline with accounting format
 
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



Susan

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


Dave F

Underline with accounting format
 
Yeah that's the way to do it. Apply the appropriate border from the
formatting toolbar
--
Brevity is the soul of wit.


"Susan" wrote:

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



Will Fleenor

Underline with accounting format
 
The problem with a border is that it connects to borders in adjoining cells.
"Dave F" wrote in message
...
Yeah that's the way to do it. Apply the appropriate border from the
formatting toolbar
--
Brevity is the soul of wit.


"Susan" wrote:

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





Peter T

Underline with accounting format
 
I guess you are using 'Double Accounting' underline. Would ordinary Double
underline work better.

Regards,
Peter T

"Will Fleenor" wrote in message
...
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






All times are GMT +1. The time now is 04:04 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com