There is no reason a spreadsheet should turn your ratings into dates, and it is frankly absurd that you have to work around it. The user who asked for help is trying to rate something on a 1-to-10 scale, types "5/10," and Excel silently rewrites it as May 10 or, worse, a full date like 5/10/2026. That is not a helpful feature. That is the software deciding it knows better than the person using it, and it is exactly the kind of friction that makes people feel like they are fighting their own tools.
The practical fix is straightforward, and it is worth learning because this problem will keep showing up. You can prevent Excel from converting your input by formatting the cells as text before you type anything. Select the cells, open the Format Cells menu, choose "Text," and then type your ratings. That stops the date conversion cold. If you are working inside a text box, the same logic applies, but you may need to type an apostrophe before the number, like '5/10, which tells Excel to treat the entry as plain text. Another option is to use a custom number format that displays what you want without letting Excel reinterpret it as a date. These are not obscure workarounds; they are basic controls that should not be hidden behind a default setting that actively works against you.
What makes this frustrating is not the existence of the date feature. Dates are useful. The problem is that Excel assumes every forward slash means a date, even when the context clearly points to a rating or a fraction. That assumption forces users to stop what they are doing and debug a behavior they never asked for. It is a small thing, but small things compound. Every time you have to correct the software, you lose a little trust in it. And when you are trying to get work done, that trust matters more than any shortcut the program thinks it is giving you.
So here is the takeaway: learn the text format trick, use the apostrophe when you need a quick fix, and do not feel bad about overriding Excel's defaults. The tool is supposed to serve you, not the other way around. If you are tired of fighting this battle, know that you are not alone, and the fix is simple enough to remember. Next time you type a rating, you will not have to wonder what date you are about to get. You will just get the number you intended, and that is exactly how it should work.