| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| pivot table format | Excel Discussion (Misc queries) | |||
| using pivot table to crosstab text value data | Excel Discussion (Misc queries) | |||
| Pivot Table Format | Excel Discussion (Misc queries) | |||
| Excel Pivot Table Plugin? (crosstab to data table) | Excel Discussion (Misc queries) | |||
| Help on Pivot Table Format | Excel Worksheet Functions | |||
Linear Mode
