Results 1 to 5 of 5

Help with converting decimals into whole in a Pivot table

Threaded View

  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

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