View Single Post
  #2   Report Post  
Niek Otten
 
Posts: n/a
Default 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.