how to insert tally mark in excel


Shane Devenshire


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


We can't put a slash though every 5.



Gord Dibben

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

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

in cell B1 with your number in A1

Now put this in C1

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

Now choose the TALLY FONT for Column C

That is all... :)

Dave Peterson

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,

Gord Dibben

Thanks Sheeloo

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



Sep 17, 2013
Reaction score

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.

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 function in excel 1
Tallies 1
Formula in excel to run a tally 1
tally 1
excel does not mark cell with inserted comments. 2
Tally feature 2
How to count/tally entries? 1
Array tally 3