Thread: Format mask percent column.
2012-06-15, 13:53 #1
- Join Date
- May 2010
- Northern Illinois
- 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.
I want a double accounting underline that is same length as in sample below.
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!
+ 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!
2012-06-15, 17:34 #2
- Join Date
- May 2002
- Canberra, Australian Capital Territory, Australia
- 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: ClarificationCheers,
[MS MVP - Word]