+ Reply to Thread
Results 1 to 3 of 3

Number appear as Text in Pivot Table

  1. #1
    Registered User
    Join Date
    10-09-2017
    Location
    Stavanger, Norway
    MS-Off Ver
    O365
    Posts
    78

    Number appear as Text in Pivot Table

    I have a TABLE of data, from which I have generated a Pivot Table, when I place an array (column from Table) of numbers in VALUES, Excel is seeing this data as text rather than a number so that I cannot plot is correctly (I wish to show the Field settings as MAX or AVERAGE but can only show COUNT. I am sure that the original data is a number, it is a calculation.

    Any suggestions. Am working with Excel Office 365 ProPlus.

    Simon

  2. #2
    Forum Expert Olly's Avatar
    Join Date
    09-10-2013
    Location
    Darlington, UK
    MS-Off Ver
    Excel 2016, 2019, 365
    Posts
    6,284

    Re: Number appear as Text in Pivot Table

    Please attach a sample workbook (not a picture or pasted copy). Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

    Remember to desensitize the data.

    Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.
    let Source = #table({"Question","Thread", "User"},{{"Answered","Mark Solved", "Add Reputation"}}) in Source

    If I give you Power Query (Get & Transform Data) code, and you don't know what to do with it, then CLICK HERE

    Walking the tightrope between genius and eejit...

  3. #3
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,917

    Re: Number appear as Text in Pivot Table

    Quote Originally Posted by SimonCampbell View Post
    ...when I place an array (column from Table) of numbers in VALUES...

    Simon
    How do you know they are numbers and not text looking like values?
    Where is this data coming from? If it is coming from another program (ie not excel), then excel is probably converting the original values to text.

    Do a quick test of =istext(cell-ref)...if it comes back TRUE, you are dealing with text, not numbers
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

+ 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. Show number of times a text appears in pivot table (graph)?
    By Smoka in forum Excel Charting & Pivots
    Replies: 5
    Last Post: 11-12-2018, 06:42 PM
  2. Show number of times a text appears in pivot table (graph)?
    By Smoka in forum Excel - New Users/Basics
    Replies: 1
    Last Post: 11-10-2018, 12:10 PM
  3. [SOLVED] Transpose text only data into table (like pivot table but with text only)
    By FelicityHall in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 08-20-2015, 04:54 PM
  4. Calculating number of times individual number appears in a pivot table
    By snoopy1461 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 10-15-2014, 08:39 AM
  5. Replies: 1
    Last Post: 05-16-2014, 07:34 PM
  6. [SOLVED] Match row that contains text text string; list associated values from pivot table
    By ACurtis802 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-29-2009, 07:50 PM
  7. Replies: 2
    Last Post: 05-08-2006, 02:55 PM

Tags for this Thread

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