Error Checking Excel 2002

  • Thread starter Thread starter Carie
  • Start date Start date
C

Carie

Is there a way to permanently turn off the Error Checking
and make Excel 2002 run like 2000? I am tired of having
to "convert text to numbers" when I copy/paste from
another source. Excel 2000 and prior always recognized a
number as a number. When you have a large amount of data
you're working with, this can be a pain. I do know you
can use VBA, but you can't always distribute that to all
users.
 
Tools>options>error checking, there you can remove the checkmarks you don't
want,
I also remove thing like show paste options button and show insert options
button
under tools>options>edit plus the smart tags under tools>autocorrect
 
Back
Top