Is $9,500.00 formatted as currency or have you typed the $ into the cell? Are any of the numbers actually text?