Numbers change to dates automatically
Type 2,5 instead of 2.5
--
Kind regards,
Niek Otten
"Aa" wrote in message
...
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.
|