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
" / " Changing Decimal number format to Fraction on Protected Cell laudie Excel Worksheet Functions 0 November 15th 05 01:12 AM
accounting format for zero show 0.00 in one cell "-" in another SundanceKidLudwig Excel Discussion (Misc queries) 5 August 26th 05 02:06 PM
Keep custom format in new worksheet Buddy Excel Discussion (Misc queries) 2 March 14th 05 10:03 AM
Display 0's in Accounting format markvi Excel Discussion (Misc queries) 3 March 10th 05 09:33 PM
How to format a date to a different format Laura Excel Discussion (Misc queries) 1 March 5th 05 09:59 PM


All times are GMT +1. The time now is 04:21 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"