View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Lea from CA[_2_] Lea from CA[_2_] is offline
external usenet poster
 
Posts: 10
Default Defaulting to date format

Up until a few weeks ago all was well with Excel07. Then it started to
change the default number format to a date format. When I import a file to
excel or do a copy paste, excel automatically formats numbers as dates.
Suggestion was to create a template and save in xlstart but then everything
will be formated as general. why did excel stop automatically detecting
number formats? how can I change the default settings?