Format Using Reating Symbols

  • Thread starter Thread starter Needy Ned
  • Start date Start date
N

Needy Ned

I want to format cells so that the numer entered appears as a symbol that
repeats up to the value of the number (e.g. the number "2" would appear as
"√√", "3" would appear as "√√√", etc.). Any ideas om how to help. I know
that I have done it before, but I forget how I did it.
 
I can't think of an easy formatting solution, but as a formula in another
column try =REPT("?",A2)
 
Thanks, but that won't work, becuase I want to treat them as numbers (e.g.
sum, count, etc.). I used a custom format and put a "√" in the "type" box,
but it places only one "√" no matter what the value.
 
Thanks, but that won't work, becuase I want to treat them as numbers (e.g..
sum, count, etc.). šI used a custom format and put a "–" in the "type" box,
but it places only one "–" no matter what the value.
Click to expand...

Why wouldn't it work? You have your number in another column, possibly
hidden. And any counting or summing would be done on the "real" number
column, while the visible column is the checkmarks.
 
Back
Top