Read this tip to make your life smarter, better, faster and wiser. LifeTips is the place to go when you need to know about Excel 97 and other Software topics.
Excel sometimes gets confused as to whether a cell contains text or numbers. The default alignment for text is left and for numbers it is right - this makes it very easy to see if a cell or cells are not formatted as the correct type. I'd suggest that wherever possible you leave the defaults as they are.