Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel,microsoft.public.excel.programming,microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel,microsoft.public.excel.programming,microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
why not underline the CELL, not the text/numeric?
format, cells, borders, double underline (somebody may have a better idea, tho!) :D susan |
#3
![]()
Posted to microsoft.public.excel.programming,microsoft.public.excel.worksheet.functions,microsoft.public.excel
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.programming,microsoft.public.excel.worksheet.functions,microsoft.public.excel
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel,microsoft.public.excel.programming,microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
" / " Changing Decimal number format to Fraction on Protected Cell | Excel Worksheet Functions | |||
accounting format for zero show 0.00 in one cell "-" in another | Excel Discussion (Misc queries) | |||
Keep custom format in new worksheet | Excel Discussion (Misc queries) | |||
Display 0's in Accounting format | Excel Discussion (Misc queries) | |||
How to format a date to a different format | Excel Discussion (Misc queries) |