Underline % format

  • Thread starter Thread starter Will Fleenor
  • Start date Start date
W

Will Fleenor

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
(e-mail address removed)
 
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" <[email protected]>
w7yuuuuuuuuuuu][[[[[56tttttttttttttttttttt[[[[[[[[3222rote in message
news:[email protected]...
 
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 said:
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" <[email protected]>
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
(e-mail address removed)
Click to expand...
Click to expand...
 
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 said:
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 said:
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" <[email protected]>
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
Click to expand...
format
do
it?
Will Fleenor
(e-mail address removed)
Click to expand...
Click to expand...
Click to expand...
 
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!
==============================================

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 said:
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" <[email protected]>
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
(e-mail address removed)
Click to expand...
Click to expand...
 
Back
Top