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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

tally marks 1
Mark-as-read problem 0
Converting a letter to a numeric value 4
Tally marks 2
Automatic indexing in footnotes - solved 0
how to insert tally mark in excel 7
Tally Survey Result in Excel 1
How do I set a scroll area in excel 2007 without using VBA? 5

Top