Regardless, it sounds like you values are stored as Text instead of as
numbers.

Select a blank cell, then do Edit=copy

then select the offending cells and do Edit=Paste Special, select Values
and ADD.

This should convert them back to being stored as numbers.

--
Regards,
Tom Ogilvy


"DavidB" wrote:


What do you have the cell formatted as?

Currency