Try formatting the cell as Text first
or
precede your entry with an apostrophe: '2.5

Do you use a dot for the thousands separator?

It sounds like a confusing choice for a date separator to me.

Aa wrote:

I have dot as a default date separator in regional settings (comma is a
default decimal separator). Now, if i type in a cell e.g. 2.5 it becomes a
date. Is there a way to prevent this change to date? I don't want to change
reginal settings.

--

Dave Peterson