How to turn off autoformating?

  • Thread starter Thread starter Bob J.
  • Start date Start date
B

Bob J.

How do I turn off autoformating in Excel XP? For
example, if I type 1/4 in a cell Excell automatically
converts it to January 4. I don't want a date, I want
what I entered. Also if I enter (2) Excel automatically
converts it to -2. I know that I can enter a quote
before I type the entry such as '1/4 but I would prefer
not to have to enter the additional keystroke.
 
You formatted the range of cells to Text and then _typed_ 1/4 and it still got
converted?
 
Back
Top