Pivot (Crosstab) Table format
 

When I double click a cell that has a roll-up value in it, another Excel
sheet opens with the detail. How do I format the results detail? It is a
series of numbers and the decimal places will go out 16 places, although the
crosstab table looks just fine..

Thanks

Dave K

Pivot (Crosstab) Table format
 

Format it the way you like.

I guess your real question is why doesn't excel keep the same formatting as the
worksheet that contained the original data.

It doesn't. I don't think you'll be able to change that behavior.

Dave wrote:

When I double click a cell that has a roll-up value in it, another Excel
sheet opens with the detail. How do I format the results detail? It is a
series of numbers and the decimal places will go out 16 places, although the
crosstab table looks just fine..

Thanks

Dave K

--

Dave Peterson

Pivot (Crosstab) Table format
 

Will the newest version of Excel help this?

"Dave Peterson" wrote:

Format it the way you like.

I guess your real question is why doesn't excel keep the same formatting as the
worksheet that contained the original data.

It doesn't. I don't think you'll be able to change that behavior.

Dave wrote:

When I double click a cell that has a roll-up value in it, another Excel
sheet opens with the detail. How do I format the results detail? It is a
series of numbers and the decimal places will go out 16 places, although the
crosstab table looks just fine..

Thanks

Dave K

--

Dave Peterson

Pivot (Crosstab) Table format
 

Maybe someone running xl2007 will jump in.

Dave wrote:

Will the newest version of Excel help this?

"Dave Peterson" wrote:

Format it the way you like.

I guess your real question is why doesn't excel keep the same formatting as the
worksheet that contained the original data.

It doesn't. I don't think you'll be able to change that behavior.

Dave wrote:

When I double click a cell that has a roll-up value in it, another Excel
sheet opens with the detail. How do I format the results detail? It is a
series of numbers and the decimal places will go out 16 places, although the
crosstab table looks just fine..

Thanks

Dave K

--

Dave Peterson


--

Dave Peterson

Pivot (Crosstab) Table format
 

In Excel 2007 it will create a table in the default table style. The
number columns are all in General format.

Dave Peterson wrote:
Maybe someone running xl2007 will jump in.

Dave wrote:

Will the newest version of Excel help this?

"Dave Peterson" wrote:


Format it the way you like.

I guess your real question is why doesn't excel keep the same formatting as the
worksheet that contained the original data.

It doesn't. I don't think you'll be able to change that behavior.

Dave wrote:

When I double click a cell that has a roll-up value in it, another Excel
sheet opens with the detail. How do I format the results detail? It is a
series of numbers and the decimal places will go out 16 places, although the
crosstab table looks just fine..

Thanks

Dave K

--

Dave Peterson





--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html

Pivot (Crosstab) Table format
 

Thakn yuo, ma'am.

<vbg

Debra Dalgleish wrote:

In Excel 2007 it will create a table in the default table style. The
number columns are all in General format.

Dave Peterson wrote:
Maybe someone running xl2007 will jump in.

Dave wrote:

Will the newest version of Excel help this?

"Dave Peterson" wrote:


Format it the way you like.

I guess your real question is why doesn't excel keep the same formatting as the
worksheet that contained the original data.

It doesn't. I don't think you'll be able to change that behavior.

Dave wrote:

When I double click a cell that has a roll-up value in it, another Excel
sheet opens with the detail. How do I format the results detail? It is a
series of numbers and the decimal places will go out 16 places, although the
crosstab table looks just fine..

Thanks

Dave K

--

Dave Peterson




--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html

--

Dave Peterson

Pivot (Crosstab) Table format
 

Thanks - sounds like a solid "No"!

Dave

"Dave Peterson" wrote:

Thakn yuo, ma'am.

<vbg

Debra Dalgleish wrote:

In Excel 2007 it will create a table in the default table style. The
number columns are all in General format.

Dave Peterson wrote:
Maybe someone running xl2007 will jump in.

Dave wrote:

Will the newest version of Excel help this?

"Dave Peterson" wrote:


Format it the way you like.

I guess your real question is why doesn't excel keep the same formatting as the
worksheet that contained the original data.

It doesn't. I don't think you'll be able to change that behavior.

Dave wrote:

When I double click a cell that has a roll-up value in it, another Excel
sheet opens with the detail. How do I format the results detail? It is a
series of numbers and the decimal places will go out 16 places, although the
crosstab table looks just fine..

Thanks

Dave K

--

Dave Peterson




--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html

--

Dave Peterson

Pivot (Crosstab) Table format
 

That's the way I read it, too.

Dave wrote:

Thanks - sounds like a solid "No"!

Dave

"Dave Peterson" wrote:

Thakn yuo, ma'am.

<vbg

Debra Dalgleish wrote:

In Excel 2007 it will create a table in the default table style. The
number columns are all in General format.

Dave Peterson wrote:
Maybe someone running xl2007 will jump in.

Dave wrote:

Will the newest version of Excel help this?

"Dave Peterson" wrote:


Format it the way you like.

I guess your real question is why doesn't excel keep the same formatting as the
worksheet that contained the original data.

It doesn't. I don't think you'll be able to change that behavior.

Dave wrote:

When I double click a cell that has a roll-up value in it, another Excel
sheet opens with the detail. How do I format the results detail? It is a
series of numbers and the decimal places will go out 16 places, although the
crosstab table looks just fine..

Thanks

Dave K

--

Dave Peterson




--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html

--

Dave Peterson


--

Dave Peterson