+ Reply to Thread
Results 1 to 5 of 5

Help with converting decimals into whole in a Pivot table

  1. #1
    Registered User
    Join Date
    05-14-2013
    Location
    NY
    MS-Off Ver
    Excel 2010
    Posts
    32

    Help with converting decimals into whole in a Pivot table

    Hello. I have a long list of numbers - some are whole numbers and some are showing 6-7 decimals. I need to be able to convert the decimals into whole numbers. the reason is that i am trying to pull a pivot to count these numbers. The pivot is counting those numbers as decimal even though i tried converting them into numbers no decimals in the data file. the pivot table won't reflect the conversion. I have tried converting them into numbers or text or general none of which helped with my pivot table.

    Please see my sample data and pivot attached.Attachment 274264 Will someone look at this and advise?

    Thank you!!
    Attached Files Attached Files

  2. #2
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    O365 v 2402
    Posts
    13,465

    Re: Help with converting decimals into whole in a Pivot table

    What do want to do with the numbers with decimals? Round down, up, round?

  3. #3
    Registered User
    Join Date
    05-14-2013
    Location
    NY
    MS-Off Ver
    Excel 2010
    Posts
    32

    Re: Help with converting decimals into whole in a Pivot table

    I need them to round to round up to whole numbers.

  4. #4
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    O365 v 2402
    Posts
    13,465

    Re: Help with converting decimals into whole in a Pivot table

    Then perhaps enter = roundup(a2,0) in col B, pull down as needed and start your PT from there?

  5. #5
    Registered User
    Join Date
    05-14-2013
    Location
    NY
    MS-Off Ver
    Excel 2010
    Posts
    32

    Re: Help with converting decimals into whole in a Pivot table

    Thank you. that was quick and easy fix..thank you!!

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Converting decimal to time in a pivot table....
    By hello its dean in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 07-15-2013, 01:41 PM
  2. Converting OLAP Pivot table to formulas
    By moty.98 in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 06-04-2013, 11:42 AM
  3. COnverting Pivot to table
    By djmatok in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 08-01-2012, 05:07 PM
  4. Converting column to rows -not pivot table
    By jartzh in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 08-05-2008, 08:28 AM
  5. Pivot table formats text data with 2 decimals
    By Don S in forum Excel General
    Replies: 3
    Last Post: 10-05-2005, 08:05 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1