Format Using Reating Symbols

[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.

 

[David Biddulph]

I can't think of an easy formatting solution, but as a formula in another
column try =REPT("?",A2)

 

[Gary''s Student]

Use two cell. In A1 enter 4, In B1 enter:

=REPT("√",A1)

 

[Needy Ned]

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.

 

[Spiky]

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.

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.