Ask Your Question

enter numerical sequences [closed]

asked 2019-10-14 11:37:30 +0200

libre_max gravatar image

updated 2019-10-14 12:02:28 +0200

I try to enter a formula as : 6-0.5*B2, I get a value or name error according to the point I replace with a comma. The left column went without issue : A2+1 : B3 is always faulty. Is it a bug ?

image view :

Lo :

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by erAck
close date 2019-10-14 16:16:44.602287


I can't upvote yet. Thanks !

libre_max gravatar imagelibre_max ( 2019-10-14 12:24:18 +0200 )edit

1 Answer

Sort by » oldest newest most voted

answered 2019-10-14 12:03:38 +0200

ajlittoz gravatar image

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.

edit flag offensive delete link more

Question Tools

1 follower


Asked: 2019-10-14 11:37:30 +0200

Seen: 98 times

Last updated: Oct 14 '19