Thanks Dave. I have checked that all numbers are numbers using count and
numerical count.
--
With Appreciation
Glenn
Pinetown, KwaZulu Natal, South Africa


"ozgrid.com" wrote:

Decimal display maybe?



--
Regards
Dave Hawley
www.ozgrid.com
"Glenn" wrote in message
...
I have cosolidated 26 sheets all in the same book with the sum function,
top
row left column. Most of the consolidation worked OK but 4 totals are
incorrect. I have checked that all the numbers to be totalled are in fact
numbers.

Please can you help
--
With Appreciation
Glenn
Pinetown, KwaZulu Natal, South Africa