Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Underline % format
|
#2
|
|||
|
|||
Just format the cells with the "percent format" of your choice, then
highlight the cell(s) again and right-click FormatCells Font tab select single accounting underline........... Vaya con Dios, Chuck, CABgx3 "Will Fleenor" w7yuuuuuuuuuuu][[[[[56tttttttttttttttttttt[[[[[[[[3222rote in message ... How can I get cells that have the % format to have underlines that are similar to what you get with the accounting format? Will a custom format do it? Will Fleenor |
#3
|
|||
|
|||
Thanks, but this is not what I am looking for. I want the underline to go
almost completely across the cell just as it does with the accounting format with numbers. Will Fleenor "CLR" wrote in message ... Just format the cells with the "percent format" of your choice, then highlight the cell(s) again and right-click FormatCells Font tab select single accounting underline........... Vaya con Dios, Chuck, CABgx3 "Will Fleenor" w7yuuuuuuuuuuu][[[[[56tttttttttttttttttttt[[[[[[[[3222rote in message ... How can I get cells that have the % format to have underlines that are similar to what you get with the accounting format? Will a custom format do it? Will Fleenor |
#4
|
|||
|
|||
A couple of other options........The "single" selection gives a longer
underline than the "single accounting" is you desire, or to underline the whole cell, you could just apply a bottom border........Right-click FormatCells Border pick a lineweight and color and click the bottomborder icon.......or just click the "Drawing" icon in the toolbar and draw a custom line........... Vaya con Dios, Chuck, CABGx3 "Will Fleenor" wrote in message ... Thanks, but this is not what I am looking for. I want the underline to go almost completely across the cell just as it does with the accounting format with numbers. Will Fleenor "CLR" wrote in message ... Just format the cells with the "percent format" of your choice, then highlight the cell(s) again and right-click FormatCells Font tab select single accounting underline........... Vaya con Dios, Chuck, CABgx3 "Will Fleenor" w7yuuuuuuuuuuu][[[[[56tttttttttttttttttttt[[[[[[[[3222rote in message ... How can I get cells that have the % format to have underlines that are similar to what you get with the accounting format? Will a custom format do it? Will Fleenor |
#5
|
|||
|
|||
Tried this on a new sheet ... don't know why it worked!
select A1:A10 <Format <Cells <Number tab, Click "Accounting", Change "Symbol" to <None, Click "Custom" And in the "Type" window, add % signs after the last zero in each section, Click <Font tab, Choose "Single Acctg Underline" Click <OK Is that close to what you're looking for? -- HTH, RD ============================================== Please keep all correspondence within the Group, so all may benefit! ============================================== "Will Fleenor" wrote in message ... Thanks, but this is not what I am looking for. I want the underline to go almost completely across the cell just as it does with the accounting format with numbers. Will Fleenor "CLR" wrote in message ... Just format the cells with the "percent format" of your choice, then highlight the cell(s) again and right-click FormatCells Font tab select single accounting underline........... Vaya con Dios, Chuck, CABgx3 "Will Fleenor" w7yuuuuuuuuuuu][[[[[56tttttttttttttttttttt[[[[[[[[3222rote in message ... How can I get cells that have the % format to have underlines that are similar to what you get with the accounting format? Will a custom format do it? Will Fleenor |
#6
|
|||
|
|||
Quote:
_-* #,##0.00_)%_-;_-* (#,##0.00)%_-;_-* "-"?_-;_-@_- This does not work with the Accounting underlines but does with the regular Single and Double. The only other issue is that on positive percentages, it puts a small break in the underline between the number and the %. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditonal Format with a date format | Excel Discussion (Misc queries) | |||
Office2000: Conditional format behaves strangely | Excel Discussion (Misc queries) | |||
Keep custom format in new worksheet | Excel Discussion (Misc queries) | |||
How to format a date to a different format | Excel Discussion (Misc queries) | |||
copy conditional format as ACTUAL format | Excel Discussion (Misc queries) |