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 ...
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.
6 Min. reading time
15 April 2026
