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?

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?

it's four and five digit numbers separated by a comma but not by a space

"Shane Devenshire" wrote:

> 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?

When I type: 1140,21122,1111 into Excel, I get:
1,140,211,221,111

Is that what you get? If so, Excel is not adding your numbers, it's just
reformatting your entry with consistent commas -- the way most everybody
wants their numbers displayed.

To get it to stop, make sure your cell is formatted as text before you
start. It sounds like somehow your formatting got changed along the way. An
alternative, which works regardless of the cell's format, is to precede your
entry with an apostrophe (').

Regards,
Fred.

"LisaK" <(E-Mail Removed)> wrote in message
news:FAD3AC83-6814-4F68-990E-(E-Mail Removed)...
> it's four and five digit numbers separated by a comma but not by a space
>
> "Shane Devenshire" wrote:
>
>> 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?

Thanks Fred, it worked!

"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?