Hallo,
my mumbers were jumping to the left.
then I saw a dot was added (like the 12.)
in 1) I removd to dot by hand
2) 32 and 33 are not affected
3) 31 is affeced
4) dot removed by hand
if I type a number <=31 calc 24.2.0.3 converts adds a dot and takes it a date
if I remove to dot by hand it is a number again
How can I get rid of this autoformating (or is it an automatic dot-adding)?
Do you have some weird Date Acceptance Pattern set? (Tools → Options → Languages and Locales → General, Format).
Are the cells pre-formatted with some date format like DD. ? (though that should yield odd values also for input values >31).
On the other hand this all doesn’t make sense as the content gets left aligned, which indicates text instead of numeric or date values.
What’s your locale and content language anyway, maybe it’s some AutoCorrect data gone astray.
date recognition pattern is default D.M.Y;D.M.
locale is all default German
the dot is added automatically; I am not typing the dot
OK while triying I figured
the dot is indeed added automaticilly for numbers <=31
so somewhere in this table there was a cell containing “31.” (31dot)
since it a quite big table with “fake dates” any number with dot 1.-31. was existing in a cell table
zoom
an empty calc file does this - as expected -only for exsisting filled dot-numbers in cells
thanks for your hints
maked as solved
Just to make it clear, the dot was a suggested input coming from an entry above. You can turn off the suggestions by unticking in the menu Tools > AutoInput