Hi,

You mean you are typing in a text string which reads "1140,21122,1111" or do
you mean you are typing in 4 digit numbers like 1140 or 5 digit numbers like
21122?

In the first case I have never seen Excel add these together when entered as
you describe. So the answer would be 23373?


--
If this helps, please click the Yes button

Cheers,
Shane Devenshire


"LisaK" wrote:

I'm trying to type in numbers into a cell in a previously created worksheet.
The numbers are like this: 1140,21122,1111.

I hadn't changed any of the formatting in any of the cells since I created
the worksheet, but all of a sudden when I get to this cell, it is adding the
numbers together instead of listing them as above. Why did this happen, and
how can I fix it?