Cell formatting won't work
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?
|