D Dave Peterson Mar 10, 2005 #2 Do you mean have 7 in a cell (say A1) and have: ||||| || show up in B1 (say). If yes, then try a formula like: =REPT(REPT(CHAR(134),4)&" ",INT(A1/5))&REPT("|",MOD(A1,5)) You'll see something like: †††† || (nice if you're using Arial--not sure how it'll show up in the newsgroup, though.)
Do you mean have 7 in a cell (say A1) and have: ||||| || show up in B1 (say). If yes, then try a formula like: =REPT(REPT(CHAR(134),4)&" ",INT(A1/5))&REPT("|",MOD(A1,5)) You'll see something like: †††† || (nice if you're using Arial--not sure how it'll show up in the newsgroup, though.)
P Pam Hinckley Joined Apr 21, 2016 Messages 1 Reaction score 0 Apr 21, 2016 #3 This is awesome - thank you!!!!