how to insert tally mark in excel

  • Thread starter Thread starter shawn
  • Start date Start date
Hi,

Since you didn't show us what you have or what you want displayed, suppose
A1 contains 6 and you want to see |||||| in B1

=REPT("|",A6)

We can't put a slash though every 5.
 
You mean like a checkmark?

Format the cells to Marlett Font then type an "a" without quotes.


Gord Dibben MS Excel MVP
 
The process is slightly complicated ...

1. You need to install a FONT which supports tally marks...

You can get one from http://www.subtangent.com/maths/resources/tally.zip

Download the zip file and extract the ttf file and put in C:\Windows

2. Now you need to convert your numbers like this

1 to 1
..
..
6 to 51
7 to 52
..
..
11 to 551
and so on
which you can do using a formula like

=REPT(5,INT(A1/5))&MOD(A1,5)
in cell B1 with your number in A1

Now put this in C1
=B1

Copy the formulas in B1 & C1 down if you many numbers...

Now choose the TALLY FONT for Column C

That is all... :-)
 
Saved from a previous post:

I like this one (it simulates the cross mark on the 5th entry):

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

With 7 in A1, you'll see something like:
†††† ||

(nice if you're using Arial--not sure how it'll show up in the newsgroup,
though.)
 
Thanks Sheeloo

I had sort of sussed that out from watching the other posts but you just
confirmed it.


Gord
 
Sheeloo,

Thank you very much for the Tally font and especially the formula to translate regular numbers into tally marks. I am a 4th grade teacher and needed to both demonstrate the tally marks as a ways of collecting and recording data and the actual value of the tally marks to create charts.
 
Back
Top