ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Keep format in Pivot Table (https://www.excelbanter.com/excel-programming/305831-keep-format-pivot-table.html)

Beto[_3_]

Keep format in Pivot Table
 
Hi,

How do I keep the format of a sum field in a pivot table?

I mean, I put the field in the Data Area, then format the numbers (ex:
comma separator and two decimals) but then if I take the field out and
then put it back in, the numbers are unformatted again.


Any Ideas?
Regards,
--
Beto
Reply: Erase between the dot (inclusive) and the @.
Responder: Borra la frase obvia y el punto previo.


All times are GMT +1. The time now is 07:56 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com