Excel's automatic formatting of cell entries

C

Chris Gadarowski

Can someone tell me how to turn off or change Excel's
automatic formatting of cell entries? I have text that I
want preserved as text when I enter (or paste or replace!)
it but Excel gets cute, guesses it is date data and
changes the cell formatting to a date format. This is very
frustrating because it changes the values from the
original entries. And I do not have the option to use
Special Paste. And I tried setting the format of the cell
to "Text" before pasting or replacing and it still changes
the format. ARG!
Thanks.
Chris
 
Top