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