An odd question about formatting

  • Thread starter Thread starter cvgairport
  • Start date Start date
C

cvgairport

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
 
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
Click to expand...

b1: =rept("*",a1)
--ron
 
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.)
 
Back
Top