| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Subtotal won't group
Usually, when I use the subtotal function under the Data menu, I am
able to group the subtotals. I am not able to do it in one file. Is there a reason why? TIA Greg |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Subtotal won't group
Could be maybe some of the "numbers" are really TEXT that looks like numbers... Vaya con Dios, Chuck, CABGx3 "GregR" wrote: Usually, when I use the subtotal function under the Data menu, I am able to group the subtotals. I am not able to do it in one file. Is there a reason why? TIA Greg |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Subtotal won't group
On May 30, 10:31 am, CLR wrote:
Could be maybe some of the "numbers" are really TEXT that looks like numbers... Vaya con Dios, Chuck, CABGx3 "GregR" wrote: Usually, when I use the subtotal function under the Data menu, I am able to group the subtotals. I am not able to do it in one file. Is there a reason why? TIA Greg- Hide quoted text - - Show quoted text - Chuck, that was the case, but I changed them to actual numbers and it still won't group. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Subtotal won't group
Sometimes, for some reason, it's really really hard to actually convert from
TEXT over to numbers, even though it APPEARS as though the change has occured, it may not have actually done it.......try setting up a small sample to test and actually type the numbers in place and check the grouping......if it works there and still doesn't on your original data, then the conversion has not actually taken place. Vaya con Dios, Chuck, CABGx3 "GregR" wrote: On May 30, 10:31 am, CLR wrote: Could be maybe some of the "numbers" are really TEXT that looks like numbers... Vaya con Dios, Chuck, CABGx3 "GregR" wrote: Usually, when I use the subtotal function under the Data menu, I am able to group the subtotals. I am not able to do it in one file. Is there a reason why? TIA Greg- Hide quoted text - - Show quoted text - Chuck, that was the case, but I changed them to actual numbers and it still won't group. |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Subtotal won't group
On May 30, 11:10 am, CLR wrote:
Sometimes, for some reason, it's really really hard to actually convert from TEXT over to numbers, even though it APPEARS as though the change has occured, it may not have actually done it.......try setting up a small sample to test and actually type the numbers in place and check the grouping......if it works there and still doesn't on your original data, then the conversion has not actually taken place. Vaya con Dios, Chuck, CABGx3 "GregR" wrote: On May 30, 10:31 am, CLR wrote: Could be maybe some of the "numbers" are really TEXT that looks like numbers... Vaya con Dios, Chuck, CABGx3 "GregR" wrote: Usually, when I use the subtotal function under the Data menu, I am able to group the subtotals. I am not able to do it in one file. Is there a reason why? TIA Greg- Hide quoted text - - Show quoted text - Chuck, that was the case, but I changed them to actual numbers and it still won't group.- Hide quoted text - - Show quoted text - Chuck, I found the answer. There is an option under the Tools/Options/ View menu where there are windows options and the check box "outline symbols" needs to be checked. I never encountered this before and now I know. Thanks for your suggestion about the text to numbers. Greg |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Subtotal won't group
Interesting GregR..............thanks for closing the loop
Vaya con Dios, Chuck, CABGx3 "GregR" wrote in message ups.com... On May 30, 11:10 am, CLR wrote: Sometimes, for some reason, it's really really hard to actually convert from TEXT over to numbers, even though it APPEARS as though the change has occured, it may not have actually done it.......try setting up a small sample to test and actually type the numbers in place and check the grouping......if it works there and still doesn't on your original data, then the conversion has not actually taken place. Vaya con Dios, Chuck, CABGx3 "GregR" wrote: On May 30, 10:31 am, CLR wrote: Could be maybe some of the "numbers" are really TEXT that looks like numbers... Vaya con Dios, Chuck, CABGx3 "GregR" wrote: Usually, when I use the subtotal function under the Data menu, I am able to group the subtotals. I am not able to do it in one file. Is there a reason why? TIA Greg- Hide quoted text - - Show quoted text - Chuck, that was the case, but I changed them to actual numbers and it still won't group.- Hide quoted text - - Show quoted text - Chuck, I found the answer. There is an option under the Tools/Options/ View menu where there are windows options and the check box "outline symbols" needs to be checked. I never encountered this before and now I know. Thanks for your suggestion about the text to numbers. Greg |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| pasting to subtotal lines without replacing hidden -non-subtotal l | Excel Discussion (Misc queries) | |||
| Bolding the subtotal lines automaticlly When using the Subtotal fu | New Users to Excel | |||
| Group / Outline / subtotal | Excel Discussion (Misc queries) | |||
| Excel subtotal group sort | Excel Worksheet Functions | |||
| Subtotal of Subtotal displays Grand Total in wrong row | Excel Worksheet Functions | |||
Hybrid Mode
