View Single Post
  #1   Report Post  
Aa
 
Posts: n/a
Default Numbers change to dates automatically

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.