+ Reply to Thread
Results 1 to 1 of 1

Data type is changing from original type when double clicking the data in the pivot table?

  1. #1
    Forum Contributor
    Join Date
    05-07-2009
    Location
    cedar grove
    MS-Off Ver
    Excel 2003
    Posts
    133

    Data type is changing from original type when double clicking the data in the pivot table?

    Hello,

    I have a Pivot table that is oddly changing the data type from the original type (numbers) to a new type (dates)..once you double click on the data in the table...

    I have enclosed the file.....

    What is happening is, A pivot table was made from a range of cells, and even though the original data that the Pivot table is grabbing is formatted as a number, when you double click on a cell in the pivot table and it opens up a new sheet and shows the data, those number cells/fields turn into dates??

    To be more specific: Columns D and F (styles and orders) are formatted as dates (when looking at the data that is being pulled from the pivot table) but they should be numbers….they are formatted as numbers on the sheet where the data is pulled from, so I can't figure out why it is changing its type once it comes via the pivot table?

    Any help is greatly appreciated...!
    babs
    Attached Files Attached Files

+ 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. Replies: 1
    Last Post: 08-08-2012, 02:39 PM
  2. convert textbox value from string to either single or double numeric data type
    By welchs101 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-08-2011, 06:40 PM
  3. [SOLVED] Double clicking in a Pivot Table, Please HELP
    By marko in forum Excel General
    Replies: 3
    Last Post: 12-27-2005, 03:55 AM
  4. [SOLVED] Double clicking in a Pivot Table, Please HELP
    By marko in forum Excel General
    Replies: 1
    Last Post: 12-26-2005, 11:10 PM
  5. [SOLVED] get SQL Server text data type into Excel pivot table
    By Lee@360Commerce in forum Excel General
    Replies: 0
    Last Post: 08-19-2005, 07: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