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

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

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.

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.

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

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