Results 1 to 4 of 4
  1. #1
    New Lounger
    Join Date
    Jul 2003
    Location
    Washington, District Of Columbia
    Posts
    17
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Pivot Table (2000)

    Hello Out There!

    This is a pivot table conundrum. I'm creating a pivot table from another Excel spreadsheet. When attempting to sum cells from the original spreadsheet in the pivot table (under field settings), I see that it will not accomodate if the cells from the original spreadsheet are not in a formula format. Is there a quick way that I can, perhaps, add equals signs to myriad cells already containing numbers? Other suggestions welcomed.

    Many thanks!

  2. #2
    New Lounger
    Join Date
    Oct 2001
    Location
    Northern VA
    Posts
    14
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Pivot Table (2000)

    you can try this:

    say the data you need to add an = to is in column M. add a column next to it, or anywhere really, and do a concatenate formula:

    =concatenate("=",M3)

    This should give you =Number in your new column (say =56). Then just copy and paste-value (under Paste Special) back into the original column.

    If you need to hide the = and it is showing up in the cell, make sure the column M is formatted as a number. Then you can highlight that column and do a find on = and replace with =. This will then "hide" the = (and you'll just see 56 in the cell, but see =56 in the formula bar).

    A screwy way to do it, but it gets the job done.

  3. #3
    New Lounger
    Join Date
    Jul 2003
    Location
    Washington, District Of Columbia
    Posts
    17
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Pivot Table (2000)

    Many thanks and all the best to you!

  4. #4
    New Lounger
    Join Date
    Jul 2003
    Location
    Washington, District Of Columbia
    Posts
    17
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Pivot Table (2000)

    As feedback, the way I was able to get the pivot table to work was to use the "text to column" function in Excel. <img src=/S/flags/Virginia.gif border=0 alt=Virginia width=30 height=18>

Posting Permissions

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