Tally marks in an excel worksheet

[jkahn]

Is there a way to use a tally mark type system in an excel spreadsheet?

[Dave Peterson]

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

jkahn wrote:
>
> Is there a way to use a tally mark type system in an excel spreadsheet?

--

Dave Peterson