Looks like no one’s replied in a while. To start the conversation again, simply ask a new question.

Question:

Question: how can i get rid of the dots when rating something only three stars

User uploaded file


Thanks in advance for you help

MacBook Air (11-inch, Early 2014), macOS Sierra (10.12.6)

Posted on

Reply
Question marked as Solved
Answer:
Answer:

you cannot get rid of the dots (that's just the way Apple seems to have implemented it).


You can try something like this:

User uploaded file



add a formula in column A (in this example):

A2=REPT("★", B2)


this is shorthand for... select cell A2, then type (or copy and paste from here) the formula:

=REPT("★", B2)


to fill the formula down, select cell A2, copy

select cells A2 thru the end of column A, paste


now formate the cells in column B as a stepper:

User uploaded file

Posted on

Page content loaded

Question marked as Solved

Nov 16, 2017 10:43 AM in response to frfrfrwere In response to frfrfrwere

you cannot get rid of the dots (that's just the way Apple seems to have implemented it).


You can try something like this:

User uploaded file



add a formula in column A (in this example):

A2=REPT("★", B2)


this is shorthand for... select cell A2, then type (or copy and paste from here) the formula:

=REPT("★", B2)


to fill the formula down, select cell A2, copy

select cells A2 thru the end of column A, paste


now formate the cells in column B as a stepper:

User uploaded file

Nov 16, 2017 10:43 AM

Reply Helpful (1)
User profile for user: frfrfrwere

Question: how can i get rid of the dots when rating something only three stars