How to turn numbers into stars: for clear visual ratings

Turning a simple number into a visual Excel star rating takes just a few steps — no design skills needed. Using the REPEAT function alongside the Wingdings font, Excel automatically generates the correct number of stars based on any value you enter. Copy your chosen star symbol to the clipboard, paste it into the REPEAT formula, and reference the rating cell as the multiplier — the stars appear instantly. A final font change to Wingdings converts the placeholder characters into proper stars, which you can then colour to match your preferred style. Read on for the full step-by-step walkthrough to build a flexible, professional-looking rating display directly in your spreadsheet.
How to turn numbers into stars: for clear visual ratings

Ludwig U. asks:
I’ve read a lot of books in my life. For a few years now, I’ve been recording the title, author and number of pages, as well as my impressions. Now I’m planning to add a kind of note to the books. My wife gave me the idea of awarding stars, just like on the Internet. So I would like to do it this way: I would give five stars if I particularly liked a book and one ...

Premium article

This article is part of our Premium subscription. Unlimited access to over 500 guides.