Results 1 to 2 of 2
  1. #1
    New Lounger
    Join Date
    May 2010
    Location
    Northern Illinois
    Posts
    23
    Thanks
    2
    Thanked 0 Times in 0 Posts

    Format mask percent column.

    Excel 2003 and 2010. Is there a way to put a mask in custom format to get below result?
    (No, I don't want to use double line border at bottom of cell).



    Double accounting underline for a percentage type column only underlines actual number part of percent.

    100.00%
    =====


    and

    .01%
    ==



    I want a double accounting underline that is same length as in sample below.

    100.00%
    =====


    to

    .01%
    =====

  2. Subscribe to our Windows Secrets Newsletter - It's Free!

    Get our unique weekly Newsletter with tips and techniques, how to's and critical updates on Windows 7, Windows 8, Windows XP, Firefox, Internet Explorer, Google, etc. Join our 480,000 subscribers!

    Excel 2013: The Missing Manual

    + Get this BONUS — free!

    Get the most of Excel! Learn about new features, basics of creating a new spreadsheet and using the infamous Ribbon in the first chapter of Excel 2013: The Missing Manual - Subscribe and download Chapter 1 for free!

  3. #2
    Super Moderator
    Join Date
    May 2002
    Location
    Canberra, Australian Capital Territory, Australia
    Posts
    3,860
    Thanks
    0
    Thanked 179 Times in 165 Posts
    You could pre-apply Format|Format Cells|Font > Underline > Double Accounting to the whole column (or as much of it as you want formatted that way. This will underline the digits, though not the % sign. To underline the digits and the % sign, you could pre-apply Format|Format Cells|Font > Underline > Double.
    Last edited by macropod; 2012-06-15 at 17:37. Reason: Clarification
    Cheers,

    Paul Edstein
    [MS MVP - Word]

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •