I am working on a spreedsheet in Excel, however all the cells were auto sums are present merely display #####. The cells that feed them the data are fine and the sums work out fine, the formating is set to number by the way. When I set the format to general then the correct answear comes up and no #s appear. However I wanted the format as number for decimal places and so it automaticly added the '0'. Is there anything I can do here?