S
shawn
how to insert tally mark in excel
S
Shane Devenshire
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.
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.
G
Gord Dibben
You mean like a checkmark?
Format the cells to Marlett Font then type an "a" without quotes.
Gord Dibben MS Excel MVP
Format the cells to Marlett Font then type an "a" without quotes.
Gord Dibben MS Excel MVP
S
Sheeloo
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...
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...
D
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,
though.)
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.)
S
Sheeloo
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/
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/
G
Gord Dibben
Thanks Sheeloo
I had sort of sussed that out from watching the other posts but you just
confirmed it.
Gord
I had sort of sussed that out from watching the other posts but you just
confirmed it.
Gord
P
PJ
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.
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.