Posted to microsoft.public.excel.misc

time conversion[_2_] time conversion[_2_] is offline

external usenet poster

Posts: 13

Rounding up numbers in a pivot table

I have a long column of numbers in a pivot table.....all whole
numbers....that I would like to round up to the nearest 5.....ie:

52 = 55
68 = 70
33 = 35

any suggestions?

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Divide 2 pivot table numbers	DANM	Excel Worksheet Functions	4	May 1st 23 07:43 PM
rounding off numbers gives an E in pivot table	sidm via OfficeKB.com	Excel Discussion (Misc queries)	0	November 29th 07 06:41 PM
Pivot Table formatting numbers	Jock	Excel Worksheet Functions	2	August 10th 07 04:30 PM
Negative Numbers in a Pivot Table	PB	Excel Worksheet Functions	1	July 9th 07 10:46 PM
Rounding to the nearest quarter (decimal) in a Pivot table	Fred	Excel Discussion (Misc queries)	3	April 3rd 06 03:26 PM

All times are GMT +1. The time now is 03:19 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us