Hello,
If 161,162,163,164
turns to a number (commas disappearing), then obviously in your country (locale) setting, comma (,
) is used as thousands separator and LibreOffice recognizes this as a number using a thousands separator, while 15,17,34,45,46,48
doesn't look like a number using a thousand separator.Your choices are:
- Change the thousand separator by using another language for the respective cells --or
- Preprend a single quote to number sequences which could be interpreted as a number using thousands separator (i.e. enter
'161,162,163,164
) --or - Move to another separator of your number (e.g. use a semicolon like
161;162;163;164
and 15;17;34;45;46;48
Note: I'd prefer and recommend option 2.
Hope that helps.