Excel. decimal convert date

G

gt

when i use decimal seperator dot "." it automatically converts it to a date
entry. eg, i enter 1.5 and it converts it to 01.May. I want to disable this
feature. regards
 
J

Jim Rech

Excel is probably just following your Windows regional settings as it what
character is the date separator. Go into Control Panel and change it to "/"
or "-".

--
Jim
| when i use decimal seperator dot "." it automatically converts it to a
date
| entry. eg, i enter 1.5 and it converts it to 01.May. I want to disable
this
| feature. regards
 
Top