[VaSteve]

Try right clicking and use "format cells" rather than the button at the top. Maybe there's something else going on. Is it text or numbers? If text, may want to try the "clean" function under the text formulas. Maybe there's unprintable characters or a bunch of spaces some dingbat entered messing you up? I have seen people abuse excel and write letters in it to make it work with their letter head. (banghead)