You got your answers, but here's an alternative that I like:

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



cvgairport wrote:

Ok, here's a toughie. I have a list of numbers in column A and I would like
in column B a smiliar number of asterisks like this:

4 ****
1 *
9 *********

Any ideas?

Amy

--

Dave Peterson