My cells do not validate unless I double-click.
Solved
soso5984
Posted messages
4
Status
Member
-
soso5984 Posted messages 4 Status Member -
soso5984 Posted messages 4 Status Member -
Hello,
I am encountering a problem validating the cells in my Excel file. I have to double-click and press enter (the number in my cell then moves from left to right) even though automatic calculation is enabled, and it is in number format. I have searched online but found no solutions.
I hope you can help me.
Best regards
I am encountering a problem validating the cells in my Excel file. I have to double-click and press enter (the number in my cell then moves from left to right) even though automatic calculation is enabled, and it is in number format. I have searched online but found no solutions.
I hope you can help me.
Best regards
4 answers
-
Re
look in the advanced options, I think the decimal separator should not be the comma, because everything works when entering a number without a decimal.
Advanced options / Use (or not) system separators
check if the comma is the separator, otherwise change it by unchecking the box "use... or write your numbers with the selected separator.
Best regards.
--
To err is human, to persist is diabolical.
