View Single Post
  #1   Report Post  
Duke Carey
 
Posts: n/a
Default aligning small #s in wide columns

FYI - Just something I found interesting and hadn't seen discussed.

I see lots of spreadsheets where users insert empty columns to help align
small numbers under a wide column heading. To avoid that I used to do use a
custom number format that used a "_W_W" placeholder at the end to push the
numbers left in the column

An alternative is to use a General or Number numeric format combined with
right aligning the number - then indenting the number as any times as needed.
Each indent moves the number farther to the left. I've thrown an extra
'RtAlign' style incorprating this technique into Book.xlt to make it faster
to use.