Today's guest blogger is Kevin Nickell, Managing Consultant
Often I need to enter items into Excel cells and find that Excel tries to be too smart for its own good. It attempts to assume what you are trying to type and sets cell format accordingly. But, sometimes its wrong in the format it is trying to change items to. You may set the cell format to plain text over and over, and it simply changes it back.
For instance, if I tried to enter a 16 character number into a cell