Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Cell formatting won't work
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? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Cell formatting won't work
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? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Cell formatting won't work
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" wrote in message ... 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? |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Cell formatting won't work
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
CELL FORMATTING WILL NOT WORK | Excel Discussion (Misc queries) | |||
Will Conditional Formatting work? | Excel Worksheet Functions | |||
Will Conditional Formatting work? | Excel Worksheet Functions | |||
Time Formatting Does Not Work for me | Excel Discussion (Misc queries) | |||
Conditional Formatting Work around? | Excel Worksheet Functions |