# how to insert tally mark in excel

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.

Ad

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

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

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

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/

G

#### Gord Dibben

Thanks Sheeloo

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

Gord

Ad

#### pablonet

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.

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