Some of your numbers may actually be text.

Re-formatting alone does not do the trick.

Format all to General.

Copy an empty cell.

Select numbers and Paste SpecialAddOKEsc.


Gord Dibben MS Excel MVP

On Fri, 11 Aug 2006 02:04:01 -0700, Alectrical
wrote:

Hi

When I highlight a range of cells AutoSum misses certain cells, even though
all cells have the same format. The same applies when I change the format to
General, Number or Text.

Any Ideas.

Thanks
Alec