Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel,microsoft.public.excel.programming,microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 25
Default 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


  #2   Report Post  
Posted to microsoft.public.excel,microsoft.public.excel.programming,microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1,117
Default 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

  #3   Report Post  
Posted to microsoft.public.excel.programming,microsoft.public.excel.worksheet.functions,microsoft.public.excel
external usenet poster
 
Posts: 2,574
Default 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


  #4   Report Post  
Posted to microsoft.public.excel.programming,microsoft.public.excel.worksheet.functions,microsoft.public.excel
external usenet poster
 
Posts: 25
Default 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




  #5   Report Post  
Posted to microsoft.public.excel,microsoft.public.excel.programming,microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 5,600
Default 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




Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Underline % format Will Fleenor Excel Worksheet Functions 5 June 19th 13 11:18 PM
How do I single accounting underline a cell with a hidden zero in Mrs J Excel Discussion (Misc queries) 2 April 11th 09 03:24 AM
Underline with accounting format Will Fleenor Excel Worksheet Functions 4 September 21st 06 11:27 PM
Double accounting underline Jessee New Users to Excel 1 May 8th 06 06:23 AM
double accounting underline boomer Excel Discussion (Misc queries) 6 October 27th 05 03:26 PM


All times are GMT +1. The time now is 12:13 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"