According to your picture, your locale is “French” and decimal separator is comma not period.
If you enter 5.5
in a French-locale spreadsheet, the sequence is insterpreted as a string, which is confirmed by “5.5” being left-aligned instead of right-aligned for numbers.
Replacing the comma by a period should fix the problem.
To show the community your question has been answered, click the ✓ next to the correct answer, and “upvote” by clicking on the ^ arrow of any helpful answers. These are the mechanisms for communicating the quality of the Q&A on this site. Thanks!
In case you need clarification, edit your question (not an answer) or comment the relevant answer.