View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Dave O Dave O is offline
external usenet poster
 
Posts: 427
Default Data Changes itself after I have inputted.

Excel is "helpful" and tries to anticipate how you'd like the data to
display based on keystrokes you enter. When you got the displayed
result 13/02/1900 Excel thought you were entering a date, or perhaps
that cell was formatted as a date. That displayed output may also be
the result of a conflict between your computer's regional settings and
the type of data you entered.

What figure did you enter, and how is the cell formatted?