Pivot Table - Date converts wrong!
Prep for a pre-employment Excel test with Job Test Prep
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 4 of 4

Thread: Pivot Table - Date converts wrong!

  1. #1
    New Member
    Join Date
    Feb 2002
    Posts
    27
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

     
    My dates are not transferring properly into my pivot table. Can anyone help by telling my why and what to do to keep the date format I have in my original data?

    Here is an example of what all is going on:

    Original data

    1999 :formula (=DATE(RIGHT(C2,2),LEFT(C2,2),1))

    Pivot table results

    1900 :It converts to 1900, versus 1999




  2. #2
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Austin, Texas USA
    Posts
    11,654
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    What's in C2?

  3. #3
    New Member
    Join Date
    Feb 2002
    Posts
    27
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    C2= 0399

    Where 0399 = date format imported from Access, from data imported from our mainframe system.

    Thanks,
    Jason

  4. #4
    New Member
    Join Date
    Feb 2002
    Posts
    27
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

      
    I think that I may have solved the problem. I'm going to put it in the correct format before I export it to Excel which should solve the issue.

    Thanks for the help.

    Jason

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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

 

 
DMCA.com