Format an underline for zero in accounting format

T

TrishL

I am preparing financial statements on Excel. The bottom number in a
column is 0. It's underlined, but only from the left edge to the dash
that represents the 0. I think I heard once about a custom format you
could use to keep the dash, keep it lined up & have the underline go
all the way across the cell. Does anyone know how?

Thank you.
 
P

Pete_UK

You could use Conditional Formatting to do this. Assume you want this
to apply from A2 to A20 - select those cells so tht A2 is the active
cell and bring up the conditional formatting dialogue box. Choose
Formula Is rather than Cell Value Is in the first box, and put this
formula in the next box:

=AND(A2=0,A2<>"")

Click on the Format button, then the Border tab, and click to select
the bottom line. OK your way out, and Excel will have adjusted the
cell references automatically.

Hope this helps.

Pete
 
G

Gord Dibben

Format>Cells>Font>Underline>Single or Double Accounting


Gord Dibben MS Excel MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

%s in Accounting Format 9
Underline with accounting format 4
Hide zero values 2
How do I create a custom button that combines format settings? 2
Problem with MS Word paragraph and character styles: format getting messed up 2
Forumla rows and columns 3
Time format hh:nn drops leading zero 0
How to print dash ("-") for zero values 2

Top