Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formatting numbers in excel pivot
Hi
I create pivots many times and have problem in formatting number column. Everytime I change contents of pivot table,the number column returns to general state, from "coma" format. Can I save / set the format once for all ? so with whatever changes in pivot columns the number format can remain constant? Please help Thanks in Advance Shanks |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formatting numbers in excel pivot
Shanks, Formatting is a problem that can be solved by code.
I reccomend you read the questions section of this discussion group, and the problems involved in coding color and other formatting choices. Enter: Pivot Chart Formatting in the search for "General Questions" Faq's "Shanks" wrote: Hi I create pivots many times and have problem in formatting number column. Everytime I change contents of pivot table,the number column returns to general state, from "coma" format. Can I save / set the format once for all ? so with whatever changes in pivot columns the number format can remain constant? Please help Thanks in Advance Shanks |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formatting numbers in excel pivot
Hi
Double click on the relevant data field and choose NumberFormat from there, rather than formatting the cells where the PT is displayed -- Regards Roger Govier "Shanks" wrote in message ... Hi I create pivots many times and have problem in formatting number column. Everytime I change contents of pivot table,the number column returns to general state, from "coma" format. Can I save / set the format once for all ? so with whatever changes in pivot columns the number format can remain constant? Please help Thanks in Advance Shanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pivot Table Data Source external excel file | Excel Discussion (Misc queries) | |||
Pivot table error when Opening an Xml Spreadsheet from MS excel Xp | Charts and Charting in Excel | |||
How do I change the category axis number formatting in a Pivot Ch. | Charts and Charting in Excel | |||
Pivot Table Security in Excel | Excel Discussion (Misc queries) | |||
Paste rows of numbers from Word into single Excel cell | Excel Discussion (Misc queries) |