Hi.
I once had a similar problem in Excel 2000 caused, as you rightly suggested, by the different formats of the cells within the column, ie. text and numbers. Formatting the column had no effect. To solve it I copied the entire cell, then 'paste special' and select the 'add' option. This...