Underline

[steig]

I need to format columns with a consistent, user
specified, set single & double underlines.

Using cell borders spans the entire column, giving the
appearance of a single (or double) line that spans all
columns.

Using "underline" and "accounting underline" only
underlines the numbers in the current cell, instead of a
specified width.

Assume I'd like an underline 10 characters long, for
every instance I'd like to have the underline. It
doesn't matter that for a specific cell, the numbers are
only 3 characters in width. That is what I'm trying to
achieve.

Anybody know how to do this?

Thanks,
Steig

 

[BrianB]

1. Put some spaces in front of the custom number format to make a total
of 10 characters in the format..

2. Format the font as underline.

 

[JMay]

somewhat limiting <<requiring a separate cell(s)>>, but
=REPT("_",10)
If you like it, perhaps you could Insert a new row beneath and change
its height from 12.75 to 4...
Another workaround (when you don't know the best answer,,,LOL)