When I enter “7.08” into a cell it just becomes “44780”. If I enter “7,08” Calc thinks it’s text or something, and moves it to the left in the cell.
OS name, LO version, save format?
Is your cell/column/row already formatted for a specific data (like time and date or something else)?
For best advice, attach your spreadsheet to the edited question. At this step, don’t start a conversation. Your question should contain all necessary details and be self-sufficient for any casual reader.
1 Like
Just for information, 44780 is 2022-08-07 date internal representation. So for some reason (completely undiscoverable unless you address @ajlittoz’ information request), Calc treats your input as a date. Is that something with your locale? date acceptance pattern? a bug in some version? anything else?
1 Like
menu::File>New>Spreadsheet…
Enter 7.08 into one cell of a brand new sheet.
Enter 7,08 into another cell.
Finally, enter 7٫08 with an Arabic decimal separator.
Which one gives a number?
1 Like
In addition to what @ajlittoz requested the following settings under -
>Tools>Options>Language Settings are relevant here. Please inform us of what you find there for
>>Language Of>>User interface>>Formats>> Locale setting-
>>Formats>>Decimal separator key(the checkbox state, and the character -
>>Formats>>Date acceptance patterns(the exact content of the input line there)
BTW If you are on a Mac, the "Options" may be replaced with "Preferences".
1 Like
@Lupp The problem seems to have been my date acceptance patterns. I think I copied it from another country’s. It was D.M.Y;D.M;D/M/Y;D/M;D/M Y, and I changed it to D.M.Y. It has fixed the problem.
Thanks all for the help!
Since you want date recognition for D.M.Y you seem to prefer the convention of many continental European countries and surely of Germany where I am living,
If you also want the shorthand functionality of the pattern D.M for dates to enter manually, you may do as I did: Add the pattern D.M. with the second point at the end or -even better- D.M.. (with 2 points; my preference to avoid any ambiguities).
BTW: For display and textual communication use exclusively YYYY-MM-DD. It’s the only globally unambiguous and human-readable format and it is the format globally understood by Calc independent of pattern settings… (It is also a DIN standard for letters.)
2 Likes