View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Claus Busch Claus Busch is offline
external usenet poster
 
Posts: 3,872
Default Baffling sum error?

Hi Terry,

Am Mon, 28 Sep 2015 09:50:43 +0100 schrieb Terry Pinnell:

Presumably the first five entries must have become corrupted in some
obscure way?


the first five values were text formatted. Formatting them as number did
not solve the problem. In this case:
Select the numbers = Format them as numbers and then with remaining
selection goto Data = Tetx to columns = Fixed Width = Finish


Regards
Claus B.
--
Vista Ultimate / Windows7
Office 2007 Ultimate / 2010 Professional