View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Mike H Mike H is offline
external usenet poster
 
Posts: 11,501
Default enable/disable auto-convert a NUMBER to DATE

Hi,

I'm a bit surprised that Excel is interpreting 3.8 as a date but if it is
the only way i can replicate it is if somehow you have managed to get an
autocurrect option set for changing . to / so try this.

Tools|Autocorrect options

Type . in the replace box and if anything comes up in the replace-with box
delete the entry.

Mike

"Harry Nopter" wrote:

When I insert a decimal number (e.g. 3.8) in a cell, then it is automatically
shown as a date (e.g. 3-Aug-09), even if I put the number's format (at "cell
format") in the number or in the general format option. I have the 2003
Office. How can I disable this automatic feature?