On Thu, 04 Feb 2010 12:12:51 -0800, Gord Dibben <gorddibbATshawDOTca wrote:

Sounds like your numbers are Text.

Format to General or Number then copy an empty cell.

Select the range of "numbers" and EditPaste SpecialAddOKEsc.


Gord Dibben MS Excel MVP


Do the older versions work differently, Gord?

In 2007, if I, with a new workbook
Format Column A as TEXT
A1: 1
A2: 2
B1: =A1+A2
-- 3

The same occurs if I enter '1 and '2 in cells pre-formatted as General.

--ron