how to insert tally mark in excel

how to insert tally mark in excel

 

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

 

Gord,

Tally marks are a quick way of keeping track of numbers in groups of five.
One vertical line is made for each of the first four numbers; the fifth
number is represented by a diagonal line across the previous four.

See http://www.enchantedlearning.com/math/tally/

 

Thanks Sheeloo

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


Gord

 

Check out this link!

http://www.mrexcel.com/forum/showthread.php?t=284515&highlight=tally+Marks

 

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.