Thread: Rounding up numbers in a pivot table
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
time conversion[_2_] time conversion[_2_] is offline
external usenet poster
  
Posts: 13
Default 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 QuoteReply With Quote