+ 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
    Version 1708
    Posts
    26

    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 Guru Olly's Avatar
    Join Date
    09-10-2013
    Location
    Darlington, UK
    MS-Off Ver
    Excel 2016, 2019, 365
    Posts
    6,127

    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 2000/3/7/10/13/16
    Posts
    48,570

    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)

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