Advertisement

How to Format Values in the Pivot Table in Excel 2013

1 of 5

Previous Next

Click on any field in the column you want to format. Click the Fields Settings button in the Active Field group of the Analyze tab.

Excel opens the Value Field Settings dialog box.

Dummies Recommends

From Around the Web

blog comments powered by Disqus

Get the Book

Excel 2013 For Dummies (1118510127) cover image
Excel 2013 For Dummies
US $24.99 Add to Cart
Advertisement
Advertisement

Inside Dummies.com

For Dummies Mobile Apps

Make everything easier on the go! Get helpful information with our best selling apps for iPhone and iPod touch.
Make everything easier on the go! Get helpful information with our best selling apps for iPhone and iPod touch.

CAREER STRATEGIES

Job searching? Career change? Get help from our reliable tips and sound advice.
Job searching? Career change? Get help from our reliable tips and sound advice.

New — Get Ready for Windows 8

The Windows 8 Center makes learning Microsoft's latest operating system easier!
The Windows 8 Center makes learning Microsoft's latest operating system easier!

Dummies.com Sweepstakes

Win $5,000 and Personal Consultation with Finance Guru Eric Tyson!
Win $5,000 and Personal Consultation with Finance Guru Eric Tyson!