| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Pivot Table in Excel 2007
I have a column that has been formatted as an integer, no decimal. When I
create a pivot table this column shows up as currency format. Is there something I should do BEFORE starting to create a pivot table?? OMEd |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Pivot Table in Excel 2007
Just format the Pivot Table.
Put your cursor in the pivot table field and click the Field Settings button on the toolbar. Click the Format button... -- Cheers, Shane Devenshire "OldManEd" wrote: I have a column that has been formatted as an integer, no decimal. When I create a pivot table this column shows up as currency format. Is there something I should do BEFORE starting to create a pivot table?? OMEd |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Pivot Table in Excel 2007
That's a nuisance. Are you confirming there's a bug? Why does Excel change a
perfectly good format? Omen "ShaneDevenshire" wrote in message ... Just format the Pivot Table. Put your cursor in the pivot table field and click the Field Settings button on the toolbar. Click the Format button... -- Cheers, Shane Devenshire "OldManEd" wrote: I have a column that has been formatted as an integer, no decimal. When I create a pivot table this column shows up as currency format. Is there something I should do BEFORE starting to create a pivot table?? OMEd |
|
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Pivot Table in Excel 2007
As to this being a bug, I can't say. I don't know what microsoft's thoughts
were on this topic when they programmed it the way they did. Certainly one could make a case for having this feature work differently. I not at home right now so I can't test 2007 to see if it's changed. -- Cheers, Shane Devenshire "OldManEd" wrote: That's a nuisance. Are you confirming there's a bug? Why does Excel change a perfectly good format? Omen "ShaneDevenshire" wrote in message ... Just format the Pivot Table. Put your cursor in the pivot table field and click the Field Settings button on the toolbar. Click the Format button... -- Cheers, Shane Devenshire "OldManEd" wrote: I have a column that has been formatted as an integer, no decimal. When I create a pivot table this column shows up as currency format. Is there something I should do BEFORE starting to create a pivot table?? OMEd |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how to create pivot table from existing pivot table in excel 2007 | Excel Discussion (Misc queries) | |||
| Excel 2007 - Pivot Table | Excel Discussion (Misc queries) | |||
| Pivot Table in Excel 2007 : Problem with % in Table | Excel Discussion (Misc queries) | |||
| Excel 2007 Pivot Table curser pop-ups | Excel Discussion (Misc queries) | |||
| Excel 2007 Pivot Table | Excel Discussion (Misc queries) | |||
Linear Mode
