how to insert tally mark in excel

Inserting a tally mark in Excel is quite simple. Here are the steps:

1. First, select the cell where you want to insert the tally mark.
2. Next, click on the "Insert" tab in the ribbon at the top of the screen.
3. From the "Symbols" section, click on the "Symbol" button.
4. In the "Symbol" dialog box, select "Wingdings" from the "Font" dropdown menu.
5. Scroll down until you find the tally mark symbol (it looks like a vertical line with four diagonal lines crossing it).
6. Click on the tally mark symbol to select it, and then click on the "Insert" button.
7. The tally mark symbol will now be inserted into the selected cell.

Alternatively, you can also use a keyboard shortcut to insert a tally mark. Here's how:

1. Select the cell where you want to insert the tally mark.
2. Press the "Alt" key on your keyboard.
3. While holding down the "Alt" key, type
   Formula:

   "0251" 

   on the numeric keypad (make sure Num Lock is on).
4. Release the "Alt" key.
5. The tally mark symbol will now be inserted into the selected cell.

That's it! You can now use these methods to insert tally marks in Excel whenever you need them.

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.

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"shawn" wrote:

how to insert tally mark in excel

You mean like a checkmark?

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


Gord Dibben MS Excel MVP

On Sat, 7 Mar 2009 15:49:01 -0800, shawn
wrote:

how to insert tally mark in excel

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

"shawn" wrote:

how to insert tally mark in excel

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

shawn wrote:

how to insert tally mark in excel

--

Dave Peterson

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/

"Gord Dibben" wrote:

You mean like a checkmark?

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


Gord Dibben MS Excel MVP

On Sat, 7 Mar 2009 15:49:01 -0800, shawn
wrote:

how to insert tally mark in excel

Thanks Sheeloo

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


Gord

On Sat, 7 Mar 2009 16:55:01 -0800, Sheeloo <Click above to get my email id
wrote:

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/

"Gord Dibben" wrote:

You mean like a checkmark?

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


Gord Dibben MS Excel MVP

On Sat, 7 Mar 2009 15:49:01 -0800, shawn
wrote:

how to insert tally mark in excel

On Mar 8, 4:13*pm, Gord Dibben <gorddibbATshawDOTca wrote:
Thanks Sheeloo

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

Gord

On Sat, 7 Mar 2009 16:55:01 -0800, Sheeloo <Click above to get my email id
wrote:



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.

Seehttp://www.enchantedlearning.com/math/tally/

"Gord Dibben" wrote:

You mean like a checkmark? *

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

Gord Dibben *MS Excel MVP

On Sat, 7 Mar 2009 15:49:01 -0800, shawn
wrote:

how to insert tally mark in excel- Hide quoted text -

- Show quoted text -

Check out this link!

http://www.mrexcel.com/forum/showthr...ht=tally+Marks