View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Harry Nopter Harry Nopter is offline
external usenet poster
 
Posts: 1
Default enable/disable auto-convert a NUMBER to DATE

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?