How do you use tally marks in Excel?

S

Sheeloo

Following was provided by Dave Peterson
_________________________________________________________
I'd put the number in A1 and use this formula in B1:

=REPT(REPT(CHAR(134),4)&" ",INT(A1/5))&REPT("|",MOD(A1,5))
_________________________________________________________
 
Top